ExcelWorksheetReplace(String, String) Method |
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.
Namespace: ExpertXls.ExcelLibAssembly: expertxls (in expertxls.dll) Version: 10.0.0
Syntaxpublic int Replace(
string oldText,
string newText
)
Public Function Replace (
oldText As String,
newText As String
) As Integer
Parameters
- oldText String
- The text to replace.
- newText String
- The replacement text. Null or an empty string removes the old text.
Return Value
Int32The number of cells that were changed.
See Also