TdxSpreadSheetDefinedNames.Items Property

Provides indexed access to individual defined names declared in the document opened in a spreadsheet control.

Declaration

property Items[Index: Integer]: TdxSpreadSheetDefinedName read; default;

Property Value

Type	Description
TdxSpreadSheetDefinedName	A defined name in a spreadsheet document.

Remarks

To identify the total number of defined names in the collection, use the Count property.

Code Example: List All Defined Name Captions and References

The following code example lists captions and references of all defined names in the collection:

Delphi

var
  I: Integer;
  ACaption, AReference: string;
//...
for I := 0 to dxSpreadSheet1.DefinedNames.Count - 1 do
  begin
    ACaption := dxSpreadSheet1.DefinedNames.Items[I].Caption;
    AReference := dxSpreadSheet1.DefinedNames.Items[I].Reference;
    cxMemo1.Lines.Strings[I] := ACaption + ' ' + AReference;
  end;

C++

UnicodeString ACaption, AReference;
//...
for(int i = 0; I < dxSpreadSheet1->DefinedNames->Count; i++)
{
  ACaption = dxSpreadSheet1->DefinedNames->Items[i]->Caption;
  AReference = dxSpreadSheet1->DefinedNames->Items[i]->Reference;
  cxMemo1->Lines->Strings[i] = ACaption + " " + AReference;
}

Note

To obtain an individual defined name by its caption instead of an index, call the GetItemByName function.