edemaine / svgtiler

Tool for drawing diagrams on a grid, combining grids of SVGs into a big SVG figure
MIT License
61 stars 6 forks source link

Ignore hidden sheets when generating from xlsx #29

Closed jbosboom closed 5 years ago

jbosboom commented 5 years ago

Google Sheets allows hiding individual sheets in a workbook (right-click the sheet's tab and choose 'Hide sheet'; unhide from the View menu). Hiddenness is preserved in exported .xlsx files. (LibreOffice Calc shows me the first sheet even if it's hidden, but that might be a LibreOffice bug.)

If svgtiler ignores hidden sheets, we can use them instead of our current ignore system: writing (DEPRECATED) at the beginning of the sheet name and deleting the resulting SVG and PDF after generating them.