Comments (5)
Does it work fine at Roo 1.10.1?
2013/2/3 Jakub Tesinsky [email protected]
When i try to read files from test/files directory like so:
require 'roo'
puts Roo::Spreadsheet.open('Bibelbund.xls').inspect
puts Roo::Spreadsheet.open('Bibelbund.ods').inspectI get at error at trird line. xls file is read normally, reading and
inspecting ods file gives this error:/var/lib/gems/1.9.1/gems/roo-1.10.2/lib/roo/generic_spreadsheet.rb:703:in
'validate_sheet!': Error: sheet 'nil' not valid (ArgumentError) from /var/lib/gems/1.9.1/gems/roo-1.10.2/lib/roo/openoffice.rb:327:in
read_cells'
from /var/lib/gems/1.9.1/gems/roo-1.10.2/lib/roo/openoffice.rb:203:into_s' from manip.rb:14:in
inspect'
from manip.rb:14:in `—
Reply to this email directly or view it on GitHubhttps://github.com//issues/12.
from roo.
I tested this and can confirm:
ruby-1.9.3-p362/gems/roo-1.10.2/lib/roo/generic_spreadsheet.rb:703:in `validate_sheet!': Error: sheet 'nil' not valid (ArgumentError)
from /home/zero/.rvm/gems/ruby-1.9.3-p362/gems/roo-1.10.2/lib/roo/openoffice.rb:327:in `read_cells'
from /home/zero/.rvm/gems/ruby-1.9.3-p362/gems/roo-1.10.2/lib/roo/openoffice.rb:203:in `to_s'
from rootest.rb:3:in `inspect'
from rootest.rb:3:in `<main>'
This occurs on inspect. I removed the inspect and just tried to read a cell and got:
ruby-1.9.3-p362/gems/roo-1.10.2/lib/roo/generic_spreadsheet.rb:703:in `validate_sheet!': Error: sheet 'nil' not valid (ArgumentError)
from /home/zero/.rvm/gems/ruby-1.9.3-p362/gems/roo-1.10.2/lib/roo/openoffice.rb:327:in `read_cells'
from /home/zero/.rvm/gems/ruby-1.9.3-p362/gems/roo-1.10.2/lib/roo/openoffice.rb:87:in `cell'
from rootest.rb:3:in `<main>'
So I tried explicitly selecting the first sheet and get the same validate sheet error. XLS version of the same file works fine.
from roo.
Could you check whether this problem still exists in v1.11.0, which was just released?
from roo.
Just tested 1.11.0 in ruby 2.0.0p0 - everything looks fine in my test but as I recall it was a few specific sheets that gave me issues. The sheet I tested I -think- was one of those, but I may be mistaken. Consider the issue solved and close it I say.
Thanks for the improvements Empact. Roo is fantastic. Right now I'm working on a converter to output in xls and ods, including the option to use template spreadsheets. I'll give you a heads up when I release it?
from roo.
@Empact I think this should be closed as it is fixed.
from roo.
Related Issues (20)
- Missing error value: #ERROR! HOT 1
- CSV dont open when using Ruby 3.0.1 HOT 1
- expand_merged_ranges not work for ODS files
- Please release new gem version HOT 4
- nokogiri vulnerabilities
- roo attempts to open file URL without first encoding spaces in filename. HOT 1
- Is roo abandoned? HOT 9
- NoMethodError: undefined method `gsub' for nil:NilClass for links in csv formatter
- Roo set method doesn't works for ODS file. anyway to set the value in ODS file? HOT 2
- More XLSX methods
- Workaround needed for: open html-as-xls file HOT 1
- invalid value for Integer(): "" HOT 1
- Version 2.9.0 installed from RubyGems still not compatible with Ruby 3? HOT 2
- support for xlsb HOT 1
- Add support for boolean values in open office files exported via Google Sheets
- Excel can store dates in exponent form which causes dates to incorrectly parse to year 1900
- Tempfile cleanup causes warning on Ruby 3.1 when using Spring (or other forking preloader)
- [Doc] Iterate through each sheet with "each_with_pagename" not working anymore HOT 2
- previously exported Spanish accents couldn't be imported correctly.
- Incorrect date parsing in xlsx files to Sat, 15 Jul 1905 HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from roo.