search

dhatim / fastexcel

Generate and read big Excel files quickly
Other
651 stars 118 forks source link

Problem of escaping in the sheet name #281

Closed sbucci closed 1 year ago

sbucci commented 1 year ago

Hi,

In the version 0.15.2

In the node <definedName function="false" hidden="true" localSheetId="0" name="_xlnm._FilterDatabase" vbProcedure="false">&apos;T&O&apos;!$A$1:$D$1</definedName> the sheet name is not escaped.

The sheetname is correctly escaped here: <sheet name="T&amp;O" r:id="rId3" sheetId="1"/>

The consequence, the Excel file cannot be read, it's corrupt.

`<?xml version="1.0" encoding="UTF-8"?>

` Thank you
ochedru commented 1 year ago

Thank you for reporting this. Indeed, the sheet name is not escaped.