Row limit of 65536 rows on import #189

New Issue

2015-03-06T01:44:46Z

grassick commented

2015-03-06 01:44:46 +00:00

(Migrated from github.com)

I imported a very large spreadsheet using xlsx.utils.sheet_to_json and only the first 65536 rows of 100000+ were imported. There was no error or any other indication of truncation. Is there a way to increase the limit Excel 2007+ support many more.

I imported a very large spreadsheet using `xlsx.utils.sheet_to_json` and only the first 65536 rows of 100000+ were imported. There was no error or any other indication of truncation. Is there a way to increase the limit Excel 2007+ support many more.

SheetJSDev commented

2015-03-06 02:17:05 +00:00

(Migrated from github.com)

@grassick can you share a sample file that shows this problem? If you can't share it, can you check the internal range of that sheet? (if ws is the worksheet, check the value of ws['!ref'])

FWIW I just checked on a 100K row file generated by Excel 2013 and there was no issue.

@grassick can you share a sample file that shows this problem? If you can't share it, can you check the internal range of that sheet? (if `ws` is the worksheet, check the value of `ws['!ref']`) FWIW I just checked on a 100K row file generated by Excel 2013 and there was no issue.

grassick commented

2015-03-06 02:57:07 +00:00

(Migrated from github.com)

Aha! It's LibreOffice. The original Excel is A1:AY111176 and LibreOffice resaves as A1:AY65536

Thanks for your prompt response!

Aha! It's LibreOffice. The original Excel is `A1:AY111176` and LibreOffice resaves as `A1:AY65536` Thanks for your prompt response!

sunil-ideas2it commented

2016-08-30 13:32:15 +00:00

(Migrated from github.com)

@grassick Can u please tell us how you solved this problem i am facing the same thing i have around 4 lakhs of records it is parsing only 65536

reviewher commented

2017-01-06 20:00:19 +00:00

(Migrated from github.com)

@sunil-ideas2it you can manually change the worksheet !ref before using any of the utility functions. It is described in the README:

ws['!ref']: A-1 based range representing the worksheet range. Functions that work with sheets should use this parameter to determine the range. Cells that are assigned outside of the range are not processed. In particular, when writing a worksheet by hand, be sure to update the range. For a longer discussion, see http://git.io/KIaNKQ

@sunil-ideas2it you can manually change the worksheet `!ref` before using any of the utility functions. It is described in the README: > ws['!ref']: A-1 based range representing the worksheet range. Functions that work with sheets should use this parameter to determine the range. **Cells that are assigned outside of the range are not processed**. In particular, when writing a worksheet by hand, be sure to update the range. For a longer discussion, see http://git.io/KIaNKQ

Sign in to join this conversation.