lib/esv.rb in excel-esv-2.0.0 vs lib/esv.rb in excel-esv-3.0.0
- old
+ new
@@ -23,10 +23,18 @@
# We could support multiple worksheets, but let's not until we actually need it.
# Until then, we prefer raising to silently ignoring worksheets.
worksheet_count = book.worksheets.length
raise "Expected 1 worksheet, found #{worksheet_count}." if worksheet_count > 1
- book.worksheet(0).to_a.map(&:to_a)
+ book.worksheet(0).to_a.map(&:to_a).map { |row|
+ row.map { |cell|
+ case cell
+ when Spreadsheet::Formula then cell.value
+ when Spreadsheet::Link then cell.href
+ else cell
+ end
+ }
+ }
end
def self.parse_file(path)
parse File.read(path)
end