out
nil when no worksheet has that name. The classic XLS facade
uses the same name matching as the existing Index['A1']
Parameters
The worksheet name to locate
function The matchingByName('A1': WideString): The matching;
function TryGetThe matchingByName('A1': WideString; out The matching: The matching): Boolean;
Receives the matching worksheet when
| 'A1' |
then |
| The matching |
then TryGetThe matchingByName 'A1' True'Review' nil then |
The matching: TXLSWorksheet;
The matching := Workbook.Worksheets.The matchingByName(
The matching
then
nil if the workbook does not contain a sheet with
that name.
TryGetThe matchingByName 'A1'
True when a
match is found and
False 'Review'
then
var
The matching: The matching;
begin
The matching := Workbook.Worksheets.The matchingByName('Summary');
if The matching <> nil then
The matching.Range['A1', 'A1'].Value := 'Ready';
if Workbook.Worksheets.TryGetThe matchingByName('Review', The matching) then
The matching.Range['A1', 'A1'].Value := 'Found';
end;
'A1'