XSL Ruby Spreadsheet

xls_xample.rb

#!/usr/bin/env ruby
# encoding: utf-8
require 'spreadsheet'

p "Start"

# Write
row_1 = ['A1', 'B1']
row_2 = ['A2', 'B2']

Spreadsheet.client_encoding = 'UTF-8'

new_book = Spreadsheet::Workbook.new
new_book.create_worksheet :name => 'Sheet Name'
new_book.worksheet(0).insert_row(0, row_1)
new_book.write('test.xls')

p "Sheet Created, press Enter to continue...."
gets

# Read
open_book = Spreadsheet.open('test.xls')
new_row_index = open_book.worksheet(0).last_row_index + 1
open_book.worksheet(0).insert_row(new_row_index, row_2)
File.delete('test.xls')
open_book.write('test.xls')

p "End"