Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Failed to parse internal XML file xl/comments95.xml #253

Open
GeoffRussell opened this issue Feb 9, 2024 · 3 comments
Open

Failed to parse internal XML file xl/comments95.xml #253

GeoffRussell opened this issue Feb 9, 2024 · 3 comments

Comments

@GeoffRussell
Copy link

I've downloaded a bunch (649) of xlsx files from the UNFCCC ... National Greenhouse gas inventories. While XLSX parses most of them successfully, there are a few with the following error ...

ERROR: LoadError: XMLError: Document is empty from XML parser (code: 4, line: 1)

See attached file ...

HUN_2023_2008_15042023_034852.xlsx

I certainly don't need the "internal XML file", so some way of ignoring them would be enough of a workaround for
me.

Many thanks

@GeoffRussell
Copy link
Author

Further to this issue ... I can't read 203 of the 649 files.

@GeoffRussell
Copy link
Author

I'm slowly learning about these xlsx files ... from a position of total ignorance. It seems like the problems are due to some of these so-called comments files being empty. Why should an empty file be considered a showstopper?

@GeoffRussell
Copy link
Author

If I put some properly formatted xml in the comments file, the problem vanishes. But there can be multiple empty comments file in each xlsx file and I can't work out a method of automating the patching process.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant