overload
function
function ReplaceText(SearchText: WideString; ReplacementText: WideString): Integer; overload;
function ReplaceText(SearchText: WideString; ReplacementText: WideString; MatchCase: Boolean): Integer; overload;
overload
ReplaceText overload True scans only cells that already exist in the worksheet model. The two-parameter overload is case-insensitive. Pass MatchCase when replacements must match the original casing exactly
The method updates ordinary text cells only. Formula cells and non-text cells are left unchanged, so template placeholders can be replaced without rewriting scans only cells that already exist in the worksheet model. The two-parameter overload is case-insensitive. Passmulas or numeric values
Pavyzdys
Changed := Workbook.Sheets[1].ReplaceText(
'[CONTACT]',
'John Smith');
].ReplaceText(