Excel import only first 100 records but excel sheet contains almost 1400 records #2901

Closed
opened 2023-03-16 06:52:41 +00:00 by Vaival-Solutions · 2 comments

We are facing issue while uploading excel sheet containing around 1400 records but Sheetjs read method process only first 100 records.

We are facing issue while uploading excel sheet containing around 1400 records but Sheetjs read method process only first 100 records.
Owner

Does the recommendation from https://docs.sheetjs.com/docs/miscellany/errors#worksheet-only-includes-one-row-of-data apply? Check the range of the worksheet to confirm it extends to row 1400.

Does the recommendation from https://docs.sheetjs.com/docs/miscellany/errors#worksheet-only-includes-one-row-of-data apply? Check the range of the worksheet to confirm it extends to row 1400.
Owner

Try using the nodim option (https://docs.sheetjs.com/docs/api/parse-options#range) and please report back if rows are missing.

Try using the `nodim` option (https://docs.sheetjs.com/docs/api/parse-options#range) and please report back if rows are missing.
Sign in to join this conversation.
No Milestone
No Assignees
2 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: sheetjs/sheetjs#2901
No description provided.