Ruby spreadsheet example

speadsheet.rb

require 'spreadsheet'

Spreadsheet.client_encoding = 'UTF-8'

TEST_FILE = "test.xls"
MODIFIED_FILE = "modified.xls"

def inspect_sheet sheet
  sheet.each do |row|
    if row[1].is_a? Spreadsheet::Formula
      puts row[1].value
    else
      puts row[1]
    end
  end
end

book = Spreadsheet.open TEST_FILE
sheet = book.worksheet 0

inspect_sheet(sheet)

sheet[6,1] = 3.0

book.write MODIFIED_FILE

book2 = Spreadsheet.open MODIFIED_FILE
sheet2 = book.worksheet 0

inspect_sheet(sheet2)