Some excel file exported from some platform or system，when i use XLSX.read()，i found the excel content be splited，after I printed control+s，then XLSX.read() can be work correctly #2980

New Issue

guiyuxuan · 2023-09-01T01:35:38Z

guiyuxuan commented

2023-09-01 01:35:38 +00:00

No description provided.

读取方法返回.png

240 KiB

实际Excel.png

62 KiB

sheetjs commented

2023-09-01 02:04:55 +00:00

That file was generated by Apache POI.

Relevant SheetJS issue SheetJS/sheetjs#2011

Relevant Apache POI upstream issue https://bz.apache.org/bugzilla/show_bug.cgi?id=64536

There is an undocumented option nodim that you can pass to XLSX.read:

  const workbook = XLSX.read(result, { type: 'binary', nodim: true });

If this works for you, we will consider making that option official.

That file was generated by Apache POI. Relevant SheetJS issue https://git.sheetjs.com/SheetJS/sheetjs/issues/2011 Relevant Apache POI upstream issue https://bz.apache.org/bugzilla/show_bug.cgi?id=64536 There is an undocumented option `nodim` that you can pass to `XLSX.read`: ```js const workbook = XLSX.read(result, { type: 'binary', nodim: true }); ``` If this works for you, we will consider making that option official.

sheetjs commented

2023-09-01 02:08:35 +00:00

The workaround not using the undocumented option is https://docs.sheetjs.com/docs/miscellany/errors#worksheet-only-includes-one-row-of-data

Unrelated comment about the screenshotted code: if you only need to support modern Chrome, you can use the arrayBuffer method of File or Blob. It is explained in more detail in the "Blob and File" section of "Local File Access" in the docs

The workaround not using the undocumented option is https://docs.sheetjs.com/docs/miscellany/errors#worksheet-only-includes-one-row-of-data Unrelated comment about the screenshotted code: if you only need to support modern Chrome, you can use the `arrayBuffer` method of `File` or `Blob`. It is explained in more detail in the ["`Blob` and `File`" section of "Local File Access" in the docs](https://docs.sheetjs.com/docs/demos/local/file#blob-and-file)

sheetjs referenced this issue

2023-09-24 18:50:23 +00:00

Could you help to check why the data range is incorrect? #2998

sheetjs commented

2024-05-20 03:16:22 +00:00

A note about nodim was added to the docs: https://docs.sheetjs.com/docs/api/parse-options#range

A note about `nodim` was added to the docs: https://docs.sheetjs.com/docs/api/parse-options#range

sheetjs closed this issue

2024-05-20 03:16:22 +00:00

Sign in to join this conversation.