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

Why is it so slow #185

Closed
westonganger opened this issue Apr 14, 2015 · 3 comments

Comments

Projects
None yet
2 participants
@westonganger
Copy link

commented Apr 14, 2015

I like that this gem is more recent and works with XLSX and has better documentation

But why is it so ridiculously slow compared to 'spreadsheet' ?

@weshatheleopard

This comment has been minimized.

Copy link
Owner

commented Apr 14, 2015

@westonganger: I have no idea what spreadsheet is, but for one guess I can give you is because whatever that gem is, it, unlike rubyXL, does not support the full XLSX DOM model.

@westonganger

This comment has been minimized.

Copy link
Author

commented Apr 14, 2015

spreadsheet is the biggest ruby spreadsheet gem. I didnt do any benchmarks but just to let you know that in the time it took to do 2 lines in rubyXL, spreadsheet did 430.

It may be advantageous to look at their source code for any speed improvements

@weshatheleopard

This comment has been minimized.

Copy link
Owner

commented Apr 14, 2015

time it took to do 2 lines in rubyXL, spreadsheet did 430.

rubyXL works with xlsx files (Excel 2010+ open OOXML format: https://en.wikipedia.org/wiki/Office_Open_XML). spreadsheet works with xls files (Excel97-2007 proprietary Microsoft format: http://www.digitalpreservation.gov/formats/digformatspecs/Excel97-2007BinaryFileFormat%28xls%29Specification.pdf). Binary stuff works faster than XML, what a huge surprise! Next time, please ensure you compare apples to oranges.

This is not to say rubyXL cannot be optimized, it still has a lot of unneeded cruft remaining from version 1, but this gem is not my full time job.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.