spreadsheet_sample.rb

# -*- coding: utf-8 -*-
# Excelファイルを読み書きするgem "spreadsheet" sample code
# gem install spreadsheet
require "spreadsheet"

# 新規作成
book = Spreadsheet::Workbook.new
sheet = book.create_worksheet
sheet[0,0] = "testing..."
book.write("example.xls")

# 既存ファイルのopen
book = Spreadsheet.open("example.xls")
sheet = book.worksheet(0)
p str = sheet[0,0]
sheet[1,0] = "hello"
book.write("example2.xls")