HotXLS Docs

Item property

Returns a single IXLSName Interface from a Names collection. Read only IXLSName.

Syntax

property Item[Index: Variant]: IXLSName; default;
Index Required variant. The index number or defined name.

Example

This example returns the first defined name of the Worksheet one.

Result := Workbook.Worksheets[1].Names[1];
This example returns the defined name 'MyName' of the Worksheet one.

Result := Workbook.Worksheets[1].Names['MyName'];

See also

IXLSName Interface
IXLSName.Name property
IXLSName.Index property
IXLSWorkbook.Names property
IXLSWorksheet.Names property