HotXLS-dokumentation Indhold Startside Oversigt TGridToXLS IXLSWorkbook Startside Indhold Oversigt

klasse TXLSWorksheets

Enhed: lxHandle

A collection of all the Worksheet objects in the specified Workbook. Each Worksheet object represents a Worksheet

Egenskaber

Entriesegenskab Countegenskab

Metoder

Addmetode AddBeforemetode AddAftermetode AddChartSheetmetode SheetByNamemetode

Eksempel

This example creates a workbook with a summary sheet followed by two detail sheets, then iterates through the collection to name each sheet
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;

klasse TXLSWorksheets

Enhed: lxHandle

Egenskaber

Metoder

Eksempel

Se også