HotXLS Delphi Excel Read Write Library / Component Developers Guide loslab Inc.

Visible property

Determines whether the Worksheet is visible. Read/write Variant.

Syntax

property Visible: Variant;

Description

Visible can be one of these constants.
xlSheetHidden
xlSheetVisible
xlSheetVeryHidden Hides the sheet so that the only way for you to make it visible again is by setting this property to True or xlSheetVisible (the user cannot make the sheet visible).

Example

This example makes the Worksheet one invisible.

Workbook.Sheets[1].Visible := False;
This example is the same to previous.

Workbook.Sheets[1].Visible := xlSheetHidden;
This example checks visibility of sheet one.

With Workbook.Sheets[1] do begin
  if Visible = xlSheetVisible then
     Name := 'Visible Sheet' 
  else
     Name := 'InVisible Sheet';
end;
Copyright©2007-2019 loslab.com