Restituisce the worksheet object whose name matches the supplied sheet name, o
nil when no worksheet has that name. The classic XLS facade
uses the same name matching as the existing Index[SheetName]
proprietà
Sintassi
function SheetByName(SheetName: WideString): TXLSWorksheet;
function TryGetSheetByName(SheetName: WideString; out Sheet: TXLSWorksheet): Boolean;
Parametri
| SheetName |
The worksheet name to locate |
| Sheet |
Receives the matching worksheet when TryGetSheetByName returns True; receives nil when no sheet matches |
Valore restituito
The matching
TXLSWorksheet
instance, o
nil if the workbook does not contain a sheet with
that name.
TryGetSheetByName returns
True when a
match is found e
False otherwise
Esempio
var
Sheet: TXLSWorksheet;
begin
Sheet := Workbook.Worksheets.SheetByName('Summary');
if Sheet <> nil then
Sheet.Range['A1', 'A1'].Value := 'Ready';
if Workbook.Worksheets.TryGetSheetByName('Review', Sheet) then
Sheet.Range['A1', 'A1'].Value := 'Found';
end;
Vedere also