HotXLS Belgeleri İçindekiler Ana sayfa Genel bakış TGridToXLS IXLSWorkbook Ana sayfa İçindekiler Genel bakış

FindByCell yöntem

Döndürür the first defined name whose referenced range contains the specified worksheet cell. Döndürür nil when no matching range name is found

Sözdizimi

function FindByCell(SheetName: WideString; Row, Col: Integer): IXLSName; function FindByCell(SheetIndex: Word; Row, Col: Integer): IXLSName; SheetName Required WideString. The worksheet name to test SheetIndex Required Word. The one-based worksheet index to test Row Required Integer. The one-based row coordinate to test Col Required Integer. The one-based column coordinate to test

Örnek

This example finds the defined name that contains cell C3 on the Input worksheet
Workbook.Names.Add('InputBlock', '=Input!$B$2:$D$4'); Found := Workbook.Names.FindByCell('Input', 3, 3); if Assigned(Found) then Workbook.Sheets[1].Cells[3, 3].Value := Found.Name;

FindByCell yöntem

Sözdizimi

Örnek

Ayrıca bkz.