Skip to content

Instantly share code, notes, and snippets.

@montdidier
Created June 19, 2013 04:09
Show Gist options
  • Save montdidier/5811630 to your computer and use it in GitHub Desktop.
Save montdidier/5811630 to your computer and use it in GitHub Desktop.
require 'rubygems'
require 'rubyXL'
FILE = 'nokogiri_npe_example_short.xlsx'
if __FILE__ == $0
workbook = RubyXL::Parser.parse(FILE)
puts "There are #{workbook.worksheets.count} workbooks"
puts "There are #{workbook.worksheets[0].sheet_data.count} rows"
#start = 5
#for row in (start..684)
# workbook.worksheets[0].delete_row(start)
#end
#workbook.write('nokogiri_npe_example_short.xlsx')
else
puts 'This is a command-line script only.'
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment