Τεκμηρίωση HotXLS

Visible ιδιότητα

Determines whether the Worksheet is visible. Read/write Variant

Σύνταξη

property Visible: Variant;

Περιγραφή

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)

Παράδειγμα

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;