Cannot read properties of undefined (reading '65535') #2899

New Issue

Brandon-Xu · 2023-03-10T03:22:54Z

Brandon-Xu commented

2023-03-10 03:22:54 +00:00

At first, sorry about my english ┑(￣Д ￣)┍

when I read a xlsx file by

let reader = new FileReader();
      reader.readAsBinaryString(file);
      reader.onload = function (e) {
        var data = e.target.result;
        self.importing = false;
        let wb = xlsx.read(data, {type: 'binary'});

throw this

the final line in there, but I cannot understand what happend.

and I found, after resave this xlsx file by office excel, this error just disappear

but it not friendly to my client.

maybe I can get some help in there.

thanks.

I uploaded this file for debugging

At first, sorry about my english ┑(￣Д ￣)┍ when I read a xlsx file by ``` let reader = new FileReader(); reader.readAsBinaryString(file); reader.onload = function (e) { var data = e.target.result; self.importing = false; let wb = xlsx.read(data, {type: 'binary'}); ``` throw this ![1678417369458](/attachments/52e6eadd-8fca-4cf1-b4cb-6179cc80a3ea) the final line in there, but I cannot understand what happend. ![image](/attachments/1d11322f-2ad2-4776-ad07-d2204d393065) and I found, after resave this xlsx file by office excel, this error just disappear but it not friendly to my client. maybe I can get some help in there. thanks. I uploaded this file for debugging

1678417369458.jpg

19 KiB

image.png

139 KiB

throw error file.xlsx

5.4 KiB

sheetjs commented

2023-03-10 03:27:59 +00:00

Thanks for sharing!

This is confusing:

  <cellXfs count="1">
    <xf numFmtId="65535" fontId="0" fillId="0" borderId="0" xfId="0" applyNumberFormat="true"/>
  </cellXfs>

This says that the expected number format ID for the cell style is 65535.

Excel is silently correcting this.

Do you know how this file was created? It looks like an artifact of Apache POI:

<Application>Apache POI</Application>

Thanks for sharing! This is confusing: ```xml <cellXfs count="1"> <xf numFmtId="65535" fontId="0" fillId="0" borderId="0" xfId="0" applyNumberFormat="true"/> </cellXfs> ``` This says that the expected number format ID for the cell style is 65535. Excel is silently correcting this. Do you know how this file was created? It looks like an artifact of Apache POI: ```xml <Application>Apache POI</Application> ```

Brandon-Xu commented

2023-03-10 04:33:05 +00:00

Thanks for sharing!

This is confusing:
  <cellXfs count="1">
    <xf numFmtId="65535" fontId="0" fillId="0" borderId="0" xfId="0" applyNumberFormat="true"/>
  </cellXfs>
This says that the expected number format ID for the cell style is 65535.

Excel is silently correcting this.

Do you know how this file was created? It looks like an artifact of Apache POI:
<Application>Apache POI</Application>

I consulted my colleague, this file is made by my colleague's java program.

maybe we should upgrade this java program to fix this problem.

Thank you for help.

> Thanks for sharing! > > This is confusing: > > ```xml > <cellXfs count="1"> > <xf numFmtId="65535" fontId="0" fillId="0" borderId="0" xfId="0" applyNumberFormat="true"/> > </cellXfs> > ``` > > This says that the expected number format ID for the cell style is 65535. > > Excel is silently correcting this. > > Do you know how this file was created? It looks like an artifact of Apache POI: > > ```xml > <Application>Apache POI</Application> > ``` I consulted my colleague, this file is made by my colleague's java program. maybe we should upgrade this java program to fix this problem. Thank you for help.

Brandon-Xu closed this issue

2023-03-10 04:33:16 +00:00

Sign in to join this conversation.