Skip to content

Instantly share code, notes, and snippets.

@seki

seki/rubyxl_test.rb

Created October 22, 2019 00:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save seki/39fb45e87c95d6576f79ff6df9d176f1 to your computer and use it in GitHub Desktop.
Save seki/39fb45e87c95d6576f79ff6df9d176f1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
rubyxl_test.rb
require 'rubyXL'
require 'rubyXL/convenience_methods'
workbook = RubyXL::Parser.parse('201909.xlsx')
puts workbook[0].sheet_name
row = 4
while x = workbook[0][row][3].value
puts x
row += 2
end
workbook[0][4][6].value_container.value = "123.4"
workbook.save
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment