Skip to content

Instantly share code, notes, and snippets.

@zacclark
Created March 30, 2011 04:12
Show Gist options
  • Save zacclark/893849 to your computer and use it in GitHub Desktop.
Save zacclark/893849 to your computer and use it in GitHub Desktop.
Simple export to xls from Ruby.
# http://spreadsheet.rubyforge.org/file.GUIDE.html
require 'rubygems'
require 'spreadsheet'
book = Spreadsheet::Workbook.new
sheet1 = book.create_worksheet
sheet1.name = 'Testing Naming'
sheet1.row(0).push "Name", "Title"
1.upto(5) do |i|
sheet1.row(i).push "Person", "CEO"
end
sheet2 = book.create_worksheet
sheet2.name = "SECOND ONE"
sheet2.row(0).push "LOL", "LMAO"
sheet2.row(1).push "Hi", "There"
book.write './out.xls'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment