Name
xlsx.SetSheetVisibility -- set sheet visibility
Synopsis
xlsx.SetSheetVisibility(id, vis[, sheet])
Function
This function can be used to set the visibility state of the worksheet specified by the sheet parameter. The vis parameter must be one of the following special constants:

#XLSX_VISIBILITY_VISIBLE
The sheet is visible.

#XLSX_VISIBILITY_HIDDEN
The sheet is hidden but can be unhidden by users opening the XLSX file in a spreadsheet app.

#XLSX_VISIBILITY_VERYHIDDEN
The sheet is hidden and can't be unhidden by users opening the XLSX file in a spreadsheet app.

The sheet parameter is optional. If it is omitted, the worksheet set by xlsx.SetDefaultSheet() will be used. Sheet indices start at 1 for the first worksheet.

Inputs
id
identifier of the XLSX document to use
vis
desired sheet visibility state (see above for possible values)
sheet
optional: index of the worksheet to (un)select (defaults to the index of the default worksheet)

Show TOC