excelize icon indicating copy to clipboard operation
excelize copied to clipboard

[BUG] Cannot read properties of undefined (reading 'sheets')

Open alinakuchai-ideals opened this issue 11 months ago • 3 comments

🐛 Bug Report

For some files workbook.xlsx.load throws "TypeError: Cannot read properties of undefined (reading 'sheets')"

Ent 25 (dd check) – Notes – Mar 03, 2025 (2) (1).xlsx

alinakuchai-ideals avatar Mar 04 '25 16:03 alinakuchai-ideals

@alinakuchaicorp Thanks. I'll check it out later.

zurmokeeper avatar Mar 05 '25 09:03 zurmokeeper

Image

Found the problem, your xlsx format may be longer, inside is <x:workbook> this kind of tags, the current support code support is this kind of, no x: beginning, have to look at your this kind of format to be how to deal with.

@alinakuchaicorp

Or you can use a newer version of WPS or office to casually edit and save, or manually copy and re-create the file, and it should read first.

zurmokeeper avatar Mar 05 '25 14:03 zurmokeeper

Thank you. Yes, I know that re-saving file in excel helps, but thought maybe it could be fixed inside lib)

alinakuchai-ideals avatar Mar 05 '25 15:03 alinakuchai-ideals