Skip to content

Stopping on empty comment  #196

@GeoffRussell

Description

@GeoffRussell

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions