ws["!ref"] wrong value #2892

New Issue

nguyenquocthao · 2023-02-23T10:15:20Z

nguyenquocthao commented

2023-02-23 10:15:20 +00:00

In the file, the correct value for the !ref of Sheet1 is "A1:L210"; but get the value "A1:I6". Even in the https://oss.sheetjs.com/ only gets 6 rows.
Due to that, xlsx.utils.sheet_to_json or xlsx.utils.sheet_to_txt return wrong

In the file, the correct value for the !ref of Sheet1 is "A1:L210"; but get the value "A1:I6". Even in the https://oss.sheetjs.com/ only gets 6 rows. Due to that, xlsx.utils.sheet_to_json or xlsx.utils.sheet_to_txt return wrong

IT THPT.xlsx

36 KiB

sheetjs commented

2023-02-26 02:28:59 +00:00

Same story as #1601. We will eventually add an option to use the real worksheet range (follow the other issue for updates). https://docs.sheetjs.com/docs/miscellany/errors/#worksheet-only-includes-one-row-of-data describes a workaround that works in the current version.

sheetjs closed this issue

2023-02-26 02:28:59 +00:00

Sign in to join this conversation.