pythonicrubyist / creek

Ruby library for parsing large Excel files.
http://rubygems.org/gems/creek
MIT License
386 stars 109 forks source link

decimal records are not processed correctly #96

Closed crepon-philipp closed 3 years ago

crepon-philipp commented 4 years ago

I have a file containing multiple decimal values. 0.001 | 0.01 | 0.1

when parsing the data as described in README the first decimal is not returned correctly!

This is what I do:

require 'creek'
creek = Creek::Book.new 'spec/fixtures/sample.xlsx'
sheet = creek.sheets[0]
sheet.rows.each do |row|
  puts row
end

This is what I see in the console (the first value is just 1E-3 instead of 0.001): {"M2"=>"1E-3", "N2"=>"0.01", "O2"=>"0.1"}

Is that an issue or can I somehow configure the format the data is returned?