Check if worksheet is visible or hidden

aVadim483 / fast-excel-reader

Lightwight and very fast XLSX Excel Spreadsheet Reader in PHP

MIT License

63 stars 16 forks source link

Closed BlackbitDevs closed 3 months ago

BlackbitDevs commented 3 months ago

Currently it is possible to check if a worksheet is active but I did not find a way to determine if it is hidden. I don't know if this helps but PhpSpreadsheet gets this information from the field state, see https://github.com/PHPOffice/PhpSpreadsheet/blob/1c77e0049902b245c92c233aadcc834f50d246af/src/PhpSpreadsheet/Reader/Xlsx.php#L786

aVadim483 commented 3 months ago

in version v.2.18 functions isHidden() and isVisible() were added

BlackbitDevs commented 3 months ago

Works like a charm, thanks!