unhideSheet - cfsimplicity/spreadsheet-cfml GitHub Wiki

Unhides (shows) the specified hidden sheet in the UI. If a sheet name or number is not specified, the currently active sheet will be unhidden.

unhideSheet( workbook[, sheetName[, sheetNumber] ] )

Required arguments

  • workbook spreadsheet object

Optional arguments

  • sheetName string: the name of the sheet to unhide/show OR
  • sheetNumber numeric: the number (1 based, not zero-based) of the sheet to unhide/show

Chainable? Yes.

Example

spreadsheet = New spreadsheet.spreadsheet()
data = [ [ "a", "b" ], [ "c", "d" ] ]
path = ExpandPath( "test.xlsx" )
workbook = spreadsheet.newXlsx( "sheet1" )
spreadsheet.addRows( workbook, data )
  .createSheet( workbook, "sheet2" )
  .hideSheet( workbook, "sheet1" )
  .write( workbook, path, true )
workbook = spreadsheet.read( path )
spreadsheet.unhideSheet( workbook, "sheet1" )
  .write( workbook, path, true )