read-excel-file
read-excel-file copied to clipboard
(Reliability) How much rows/columns can this library handle without crashing?
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.
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.