Guest User

Untitled

a guest
Jun 20th, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. require 'rubygems'
  2. require 'spreadsheet'
  3.  
  4. book = Spreadsheet.open 'someFile.xls'
  5. sheet = book.worksheet 'someWorksheet'
  6.  
  7. cells = []
  8. sheet.each do |row|
  9. row.each do |cell|
  10. puts cell.value # this raises the error: undefined method 'value' for "SUMMARY" String
  11. end
  12. end
  13.  
  14.  
  15. # in the interpreter ...
  16.  
  17. << instance_of_a_cell.value
  18. 42
Add Comment
Please, Sign In to add comment