HotXLS Belgeleri İçindekiler Ana sayfa Genel bakış IXLSWorkbook Ana sayfa İçindekiler TXLSWorksheet

ReplaceText yöntem

Replaces text in loaded classic XLS worksheet cells and returns the number of changed cells

Sözdizimi

function ReplaceText(SearchText: WideString; ReplacementText: WideString): Integer; overload; function ReplaceText(SearchText: WideString; ReplacementText: WideString; MatchCase: Boolean): Integer; overload;

Açıklamalar

ReplaceText scans only cells that already exist in the worksheet model. The two-parameter overload is case-insensitive. Pass True for 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 formulas or numeric values

Örnek

Changed := Workbook.Sheets[1].ReplaceText( '[CONTACT]', 'John Smith');

ReplaceText yöntem

Sözdizimi

Açıklamalar

Örnek

See Also