HotXLS Delphi Excel Read Write Library / Component Developers Guide loslab Inc.
Reference > IXLSWorksheet > Names

Names property

Returns a Names collection that represents all the defined names in the specified Worksheet. Read-only IXLSNames Interface.

Syntax

property Names: IXLSNames;

Example

This example creates a new defined name for the Worksheet one, which refers to Sheet3!A2 cell. 

Workbook.Worksheets[1].Names.Add('MyName','=Sheet3!$A$2');

See also

IXLSWorkbook.Names property
IXLSNames Interface
IXLSName Interface
Copyright©2007-2019 loslab.com