單元： lxHandle
指定活頁簿中所有 Worksheet 物件的集合。每個 Worksheet 物件代表一個工作表
屬性
方法
範例
此範例建立包含一個摘要工作表和兩個明細工作表的活頁簿，然後逐一遍歷集合為每個工作表命名
var
I: Integer;
begin
Workbook.Worksheets.Add;
Workbook.Worksheets.AddAfter(Workbook.Worksheets[1]);
Workbook.Worksheets.AddAfter(Workbook.Worksheets[2]);
Workbook.Worksheets[1].Name := 'Summary';
Workbook.Worksheets[2].Name := 'North';
Workbook.Worksheets[3].Name := 'South';
for I := 1 to Workbook.Worksheets.Count do
Workbook.Worksheets[I].Range['A1', 'A1'].Value := Workbook.Worksheets[I].Name;
if Workbook.Worksheets.SheetByName('North') <> nil then
Workbook.Worksheets.SheetByName('North').Range['B1', 'B1'].Value := 'Ready';
end;
另請參閱