xlsxio icon indicating copy to clipboard operation
xlsxio copied to clipboard
verified publisher icon brechtsanders

can not get all sheet name

Open yingnierxiao opened this issue 6 years ago • 6 comments

when i use ./example_xlsxio_read can get all sheet name. xlsxio_xlsx2csv can not get all sheet name s_Block.xlsx you can use this file test.

yingnierxiao avatar Jan 20 '19 13:01 yingnierxiao

I looked into this and it appears when I re-save your file with Excel it does work. Which application generated this file?

brechtsanders avatar Jan 20 '19 16:01 brechtsanders

mac office 16.9

yingnierxiao avatar Jan 20 '19 19:01 yingnierxiao

I opened your file and saved it again with Office 16.0 and had no problems. Debugging your file it seems the code has problems iterating through all the sheets and the iterating deeper down somewhere else. I suspect "[Content_Types].xml" inside the zip archive is being opened twice like that.

brechtsanders avatar Jan 20 '19 20:01 brechtsanders

i print log,that is callback from xml lib.

yingnierxiao avatar Jan 24 '19 08:01 yingnierxiao

I don't understand what you are trying to say. Can you explain?

brechtsanders avatar Jan 24 '19 20:01 brechtsanders

Could you try to reproduce your issue with the latest version of XLSX I/O? If you still gave it please send an .xlsx file that the problem can be reproduced with.

brechtsanders avatar Mar 19 '20 15:03 brechtsanders