You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
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.
The text was updated successfully, but these errors were encountered: