Click or drag to resize

XlsWorksheet Replace Method (String, String , Boolean)

Replaces cells' values with new data.
Examples
The following code snippet illustrates how to replace the string with array of string values:
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 array of string values</para><para>string oldValue = "Find";</para><para>string[] newValues = { "X values", "Y values" };</para><para>worksheet.Replace(oldValue, newValues , true);</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[] newValues,
	bool isVertical
)

Parameters

oldValue
Type: System String
String value to replace.
newValues
Type: System String
Array of new values.
isVertical
Type: System Boolean
Indicates whether array should be inserted vertically.

Implements

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