search

doy / spreadsheet-parsexlsx

parse XLSX files
http://metacpan.org/release/Spreadsheet-ParseXLSX
27 stars 35 forks source link

support sheet state veryHidden #96

Closed iynehz closed 1 year ago

iynehz commented 4 years ago

A sheet can be set to veryHidden via VBA macro and can only be unhidden via VBA. See https://docs.microsoft.com/en-us/office/troubleshoot/excel/hide-sheet-and-use-xlveryhidden#hiding-a-sheet-with-a-visual-basic-macro

The Python xlsx modules support veryHidden. See, https://github.com/chronossc/openpyxl/blob/5f6a7b80d2f58b089ec6ca19cac22c9e95bb04c0/openpyxl/worksheet.py#L199 https://xlrd.readthedocs.io/en/latest/api.html#xlrd.sheet.Sheet.visibility

This Spreadsheet::ParseXLSX is the best xlsx parser module in the Perl space. We need it to also support veryHidden!

warnes commented 3 years ago

Per #97, please create a PR at https://github.com/r-gregmisc/spreadsheet-parsexlsx.