creek
creek copied to clipboard
pythonicrubyist
Ruby library for parsing large Excel files.
I've isolated this to creek (2.5.3, rails 7.0.3, cruby 3.0.3) but haven't figured out exactly why.. we store some xlsx files inline as bytea columns and load them into the...
Wondering if there is a quick way to determine the number of rows. Like as `wc -l` for CSV files.
Zip::Error (Zip end of central directory signature not found)
Hey guys. I was getting this error here when trying to read a XLSX spreadsheet remotely with 5k+ rows. `No such file or directory @ rb_sysopen - /tmp/open-uri20220126-8-xdogjo` - Example...
We've run into an issue with parsing an XLSX when the nodes are namespaced (e.g. ``). ~This PR addresses that issue by using the [`local_name`](https://nokogiri.org/rdoc/Nokogiri/XML/Reader.html#local_name-instance_method) method when looking for `row`,...
When reading an excel file that is exported from other libraries, for example caxlsx https://github.com/caxlsx/caxlsx The library generates Excel with floats and integers represented with t="n", for example from the...
As described in the title, `sheet.rows.to_a.first` will return `{}` if the first row only contains one image and without any text. Another issue is, if one row, let's say the...
My remote url is `https://host/xxxx?token=xxx&e=xxxx&attname=test.xlsx` When url request query params reverse , like 'attname=text.xlsx&e=xxxx&token=xxxx' I get a `RuntimeError: Not a valid file format.` But use `xlsx` end of url I...
We upgraded to rails 7.1.3 and at the same time I upgraded our version of creek from 2.5.3 to 2.6.3. After deploying the new rails version, we noticed our memory...
Starting with Creek 2.6.2, we were getting the following exception when stitching together large Excel documents: ``` NoMethodError: undefined method `any?' for nil:NilClass\n/usr/local/bundle/ruby/2.7.0/gems/creek-2.6.3/lib/creek/sheet.rb:107:in `block (3 levels) in rows_generator'\n\t/usr/local/bundle/ruby/2.7.0/gems/nokogiri-1.13.10-x86_64-linux/lib/nokogiri/xml/reader.rb:100:in `each'\n\t/usr/local/bundle/ruby/2.7.0/gems/creek-2.6.3/lib/creek/sheet.rb:106 ```...
Metadata
Owner
Metadata
Ruby library for parsing large Excel files.