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

Stopping on empty comment #196

Open
GeoffRussell opened this issue Feb 10, 2024 · 0 comments
Open

Stopping on empty comment #196

GeoffRussell opened this issue Feb 10, 2024 · 0 comments

Comments

@GeoffRussell
Copy link

Not sure if this issue is best dealt with here or in XLSX.

I have 600 or so xlsx files and about 200 of them can't be parsed because of empty comment files. The error returned is ...

EzXML.XMLError(1, 4, "Document is empty", 3, 1)

So the xlsx file has a reference to xl/commentsNN.xml but that file is empty and XLSX stops.
If I put some valid xml into the file, then the parse continues and all is well. I'm not interested in the comments anyway. If I could find a way to automatically patch the files, I would, but haven't thought of a way so far.

Is there perhaps some kind of flag that could be set to ignore this situation ... just return an empty string or something appropriate? comment32 is blank in the attached file. Some of my files have many blank comments, others just one.

NLD_2023_1990_13042023_151118.xlsx

Any ideas on how I can deal with this problem will be most welcome.

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