Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- require 'rubygems'
- require 'spreadsheet'
- def get_vals
- book = Spreadsheet.open 'someFile.xls'
- sheet = book.worksheet 'someWorksheet'
- cells = []
- sheet.each do |row|
- row.each do |cell|
- puts cell.value # this raises the error: undefined method 'value' for "SUMMARY" String
- end
- end
- cells
- end
- # in the interpreter call
- get_vals
Add Comment
Please, Sign In to add comment