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

See Also

LEADWorkbook Class

LEADWorkbook Members

Leadtools.Document.SheetEditor Namespace

Help Version 23.0.2024.5.29
Products | Support | Contact Us | Intellectual Property Notices
© 1991-2024 LEAD Technologies, Inc. All Rights Reserved.

Leadtools.Document.SheetEditor Assembly
Products | Support | Contact Us | Intellectual Property Notices
© 1991-2023 LEAD Technologies, Inc. All Rights Reserved.