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

(Reliability) How much rows/columns can this library handle without crashing? #66

Open
Manu-Sakrepatna opened this issue Jan 8, 2020 · 1 comment

Comments

@Manu-Sakrepatna
Copy link

Could you please share the upper limit on number of rows and columns in a sheet and also the number of sheets in an workbook?.. [so that read-excel-file can successfully handle the file]
I am using this library. But want to make sure that to what extent it can handle the rows and column.

@catamphetamine
Copy link
Owner

catamphetamine commented Jan 8, 2020

I guess no one would be able to tell that.
Other people can report their stats here.
For our project, it's quick for files containing less that 100 rows.
For a file having 2000 rows and 20 columns on a modern mid-tier CPU it parses the file (using a "schema") for 3 seconds (blocking) with 100% single CPU core usage.
So I guess this library really isn't suitable for huge spreadsheets.
I'd use it for files less than 100 rows for optimal performance.

@catamphetamine catamphetamine changed the title Upper Limit on number of rows, columns and sheets (Reliability) How much rows/columns can this library handle without crashing? Feb 15, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants