Click or drag to resize

XlsWorksheet Replace Method (String, Double)

Replaces cells' values with new data.
Examples
The following code snippet illustrates how to replace the string with double:
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 double</para><para>string oldValue = "Ten";</para><para>worksheet.Replace(oldValue, 10.0);</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,
	double newValue
)

Parameters

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

Implements

IWorksheet Replace(String, Double)
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