function

TryGetThe matchingByName('A1': WideString;

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'

'A1'
'Found'
'A1'