Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Only parse specific sheets in a workbook? #169

Open
btrepp opened this issue Jan 7, 2015 · 3 comments
Open

Only parse specific sheets in a workbook? #169

btrepp opened this issue Jan 7, 2015 · 3 comments

Comments

@btrepp
Copy link
Contributor

btrepp commented Jan 7, 2015

I'm wanting to extract data out of a certain sheet in a workbook.
The gem seems to process everything into memory. Some of the other sheets can be quite large.

Is there a way to tell the gem to only parse a certain sheet I am interested in?.

@weshatheleopard
Copy link
Owner

So far it is not possible, although I believe it can be implemented (although in that case the spreadsheet will become read-only, and it will not be possible to save it). Can you propose an API for that functionality?

@btrepp
Copy link
Contributor Author

btrepp commented Jan 7, 2015

Off the top of my head the same API etc would be cool, but perhaps just lazily evaluated?.

Eg returning the same workbook but only accessing the sheets when called?. :)

@weshatheleopard
Copy link
Owner

Lazy loading will require significant effort to implement. So far the only reasonable approach I see is skip parsing the sheet once we see it's not the one we want.

aliismayilov pushed a commit to aliismayilov/rubyXL that referenced this issue Mar 9, 2021
…fail

Fix Travis config so that ruby-head can actually fail.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants