Spire.XLS API

Workbook Replace Method (String, DataColumn, Boolean)

Replaces cell's value from data column values.

Examples

The following code snippet illustrates how to replace the string value with data column:

<para>//Create workbook</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>//Replace the oldValue by data column</para><para>string oldValue = "Find";</para><para>System.Data.DataTable table = new System.Data.DataTable();</para><para>table.Columns.Add("Dosage", typeof(int));</para><para>table.Rows.Add(1);</para><para>System.Data.DataColumn dataColumn = table.Columns[0];</para><para>workbook.Replace(oldValue, dataColumn, true);</para><para>//Save to file</para><para>workbook.SaveToFile("Replace.xlsx");</para>

Namespace: Spire.Xls
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)

Syntax

C++

ASP.NET

Copy

public void Replace(
	string oldValue,
	DataColumn newValues,
	bool includeColumnName
)

Public Sub Replace ( 
	oldValue As String,
	newValues As DataColumn,
	includeColumnName As Boolean
)

public:
void Replace(
	String^ oldValue, 
	DataColumn^ newValues, 
	bool includeColumnName
)

member Replace : 
oldValue : string * 
newValues : DataColumn * 
includeColumnName : bool -> unit

Parameters

oldValue: Type: System String
Value to replace.
newValues: Type: System.Data DataColumn
New data.
includeColumnName: Type: System Boolean
Indicates whether includes column name.

Reference

Workbook Class

Replace Overload

Spire.Xls Namespace

Workbook AddLanguageSpecificTextSet("LST8FCC73D6_0?cpp=::|nu=."); Replace Method (String, DataColumn, Boolean)

Parameters

Reference

Workbook Replace Method (String, DataColumn, Boolean)