simple_xlsx_reader
simple_xlsx_reader copied to clipboard
woahdae
Ruby xlsx reader to parse cell values into plain ruby primitives and dates/times.
Bumps [actions/checkout](https://github.com/actions/checkout) from 3 to 4. Release notes Sourced from actions/checkout's releases. v4.0.0 What's Changed Update default runtime to node20 by @takost in actions/checkout#1436 Support fetching without the --progress option...
![dependabot[bot] avatar](https://avatars.githubusercontent.com/in/29110?v=4 "dependabot[bot] avatar"){kind=avatar}
Trying to parse this: https://www.ercot.com/files/docs/2023/02/07/IntGenbyFuel2023.xlsx Mirrored, as ercot.com geoblocks at least Europe: [IntGenbyFuel2023.xlsx](https://github.com/woahdae/simple_xlsx_reader/files/13062272/IntGenbyFuel2023.xlsx) ``` doc = SimpleXlsxReader.open('IntGenbyFuel2023.xlsx') rows = doc.sheets.first.rows => # rows.first NoMethodError: undefined method `parse' for nil:NilClass from...
I hope this message finds you well. Firstly, I'd like to express my gratitude for the efforts put into maintaining the SimpleXlsxReader gem – it's been a valuable tool for...
In the Idiomatic section, the documentation specifies: `doc = SimpleXlsxReader.open(path_or_io)` but looking into the source code the method that receives io is `parse` Thanks for the amazing gem
Hi @woahdae, I recently found an issue when trying to read an excel file that contains several of float numbers as below ....
In my sheet I have some value than is transformed in date or number. How can I force all to be parsed as a string?
some cell is needed original string. in my case cell data is floating number(currency style), type is nil, but style is fixnum. this case cell data is casting to integer....
Fixes load from string test to actually test loading from string. Fixes #57 #58
To reproduce: - Change the load from string test to actually load from string: #57 Workaround: I haven't had time to dig into the issue. However commenting the following lines...