HotXLS 文档

Visible 属性

Determines whether the Worksheet is visible. Read/write Variant

语法

property Visible: Variant;

说明

Visible can be one of these constants
xlSheetHidden
xlSheetVisible
xlSheetVeryHidden 隐藏工作表,使其重新可见的唯一途径是把该属性设为 True 或 xlSheetVisible(用户无法让该工作表可见)

示例

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;