Click or drag to resize

XlsWorksheet Replace Method (String, String)

Replaces cells' values with new data.
Examples
The following code snippet illustrates how to replace the string with another string:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Replace the oldValue by newValue</para><para>string oldValue = "Find";</para><para>string newValue = "NewValue";</para><para>worksheet.Replace(oldValue, newValue);</para><para>//Save to file</para><para>workbook.SaveToFile("Replace.xlsx");</para>

Namespace: Spire.Xls.Core.Spreadsheet
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
public void Replace(
	string oldValue,
	string newValue
)

Parameters

oldValue
Type: System String
String value to replace.
newValue
Type: System String
New value for the range with specified string.

Implements

IWorksheet Replace(String, String)
Remarks
This can be long operation (needs iteration through all cells in the worksheet). Better use named ranges instead and call Import function instead of placeholders.
See Also