Reference>IXLSNames>Item :: Delphi + Excel

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.

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'];