Skip to content

Error when reading xlsx file which was printed in Excel and then saved #206

@arturas-vitkauskas

Description

@arturas-vitkauskas

Steps to reproduce.
Create a new workbook, print it and then save it in Excel as xlsx. When you try to read this xlsx file with the exceljs package, the following error is thrown:

Error: Unexpected xml node in parseOpen: {"name":"cp:lastPrinted","attributes":{},"isSelfClosing":false}
at [object Object].utils.inherits.parseOpen (/home/gt-st-admin/www/admin-backend/node_modules/exceljs/lib/xlsx/xform/core/core-xform.js:99:17)
at SAXStream. (/home/gt-st-admin/www/admin-backend/node_modules/exceljs/lib/xlsx/xform/base-xform.js:65:14)
at emitOne (events.js:90:13)
at SAXStream.emit (events.js:182:7)
at Object.me._parser.(anonymous function) as onopentag
at emit (/home/gt-st-admin/www/admin-backend/node_modules/exceljs/node_modules/sax/lib/sax.js:615:33)
at emitNode (/home/gt-st-admin/www/admin-backend/node_modules/exceljs/node_modules/sax/lib/sax.js:620:3)
at openTag (/home/gt-st-admin/www/admin-backend/node_modules/exceljs/node_modules/sax/lib/sax.js:801:3)
at Object.write (/home/gt-st-admin/www/admin-backend/node_modules/exceljs/node_modules/sax/lib/sax.js:1169:26)
at SAXStream.write (/home/gt-st-admin/www/admin-backend/node_modules/exceljs/node_modules/sax/lib/sax.js:227:16)
at Entry.ondata (_stream_readable.js:536:20)
at emitOne (events.js:90:13)
at Entry.emit (events.js:182:7)
at readableAddChunk (_stream_readable.js:153:18)
at Entry.Readable.push (_stream_readable.js:111:10)
at Entry.Transform.push (_stream_transform.js:128:32)

Attached test-last-printed.xlsx is a sample file to reproduce the issue.

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