Created
September 13, 2011 17:43
-
-
Save phollyer/1214475 to your computer and use it in GitHub Desktop.
Spreadsheet Gem - updating an existing sheet without changing the output location or filename
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env ruby | |
require 'spreadsheet' | |
# Begin Test | |
print "Spreadsheet Test\n" | |
# Create the rows to be inserted | |
row_1 = ['A1', 'B1'] | |
row_2 = ['A2', 'B2'] | |
# Create a new Workbook | |
new_book = Spreadsheet::Workbook.new | |
# Create the worksheet | |
new_book.create_worksheet :name => 'Sheet Name' | |
# Add row_1 | |
new_book.worksheet(0).insert_row(0, row_1) | |
# Write the file | |
new_book.write('test.xls') | |
# Wait for the user to inspect the file manually | |
print "Sheet Created, press Enter to continue...." | |
gets | |
# Open the previously created Workbook | |
open_book = Spreadsheet.open('test.xls') | |
# Get the row index in order to append a new row | |
# after any exisitng rows with data | |
new_row_index = open_book.worksheet(0).last_row_index + 1 | |
# Indicate the row index to the user | |
print "Inserting new row at index: #{new_row_index}\n" | |
# Insert row_2 | |
open_book.worksheet(0).insert_row(new_row_index, row_2) | |
# Delete the file so that it can be re-written | |
File.delete('test.xls') | |
# Write out the Workbook again | |
open_book.write('test.xls') | |
# End Test | |
print "Test Complete.\n" |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Hi, anyone knows how can I read a xlsb file with this gem? any example?
Thanks!