Replaces text in loaded classic XLS worksheet cells e returns the number of changed cells
Sintassi
function ReplaceText(SearchText: WideString; ReplacementText: WideString): Integer; overload;
function ReplaceText(SearchText: WideString; ReplacementText: WideString; MatchCase: Boolean): Integer; overload;
Osservazioni
ReplaceText esegue la scansione solo delle celle che esistono già nel modello del foglio di lavoro. L'overload a due parametri non distingue maiuscole/minuscole. Passare True for MatchCase when replacements must match the original casing exactly
The method updates ordinary text cells only. Formula cells e non-text cells are left unchanged, so template placeholders can be replaced without rewriting formulas o numeric values
Esempio
Changed := Workbook.Sheets[1].ReplaceText(
'[CONTACT]',
'John Smith');
Vedere Also