In This Topic ▼

SetSheetHidden Method

Summary

Modifies the visibility of a specified sheet within the Excel workbook. Allows for programmatically hiding or showing sheets.

Syntax

TypeScript

JavaScript

LEADWorkbook.prototype.setSheetHidden = function( 
   sheetName, 
   hidden 
)

setSheetHidden( 
   sheetName: string, 
   hidden: boolean 
): void;

Parameters

sheetName

A string specifying the name of the sheet whose visibility is to be changed. The sheet name must exactly match an existing sheet in the workbook, including case sensitivity.

hidden

A bool indicating the desired visibility state of the sheet. Set to true to hide the sheet; false to make it visible.

Requirements

Target Platforms

SetSheetHidden Method

Summary

Syntax

Parameters

Requirements

See Also