Click or drag to resize

ExcelWorksheetReplace Method

Overload List
 NameDescription
Public methodReplace(String, String) Replaces a text with another text in the cells of the worksheet that contain text, in any part of the cell and without regard to case. Formulas, numbers, dates and booleans are not changed.
Public methodReplace(String, String, ExcelFindOptions) Replaces a text with another text in the cells of the worksheet that contain text, with the specified options. With MatchEntireCellContent the whole cell text is replaced when it is equal to the old text; otherwise every occurrence of the old text in the cell is replaced. Formulas, numbers, dates and booleans are not changed.
Top
See Also