Click or drag to resize

XlsRange Replace Method (String, DataTable, Boolean)

Replaces cells' values with new data.

Namespace: Spire.Xls.Core.Spreadsheet
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public void Replace(
	string oldValue,
	DataTable newValues,
	bool isFieldNamesShown
)

Parameters

oldValue
Type: System String
Value to search for.
newValues
Type: System.Data DataTable
The replacement value.
isFieldNamesShown
Type: System Boolean
Indicates whether to insert values vertically or horizontally.
See Also