Guest User

Untitled

a guest
Jun 20th, 2018
90
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. def get_vals
  5. book = Spreadsheet.open 'someFile.xls'
  6. sheet = book.worksheet 'someWorksheet'
  7.  
  8. cells = []
  9. sheet.each do |row|
  10. row.each do |cell|
  11. cells.push cell.value if cell.is_a Spreadsheet::Formula
  12. end
  13. end
  14. cells
  15. end
  16.  
  17. # in the interpreter call
  18.  
  19. get_vals
Add Comment
Please, Sign In to add comment