Spire.XLS API

IWorkbook Replace Method (String, String , Boolean)

Replaces specified string by data from array.

Examples

The following code snippet illustrates how to replace the string with array of string values:

<para>//Create workbook</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</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>workbook.Replace(oldValue, newValues , true);</para><para>//Save to file</para><para>workbook.SaveToFile("Replace.xlsx");</para>

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

Syntax

C++

ASP.NET

Copy

void Replace(
	string oldValue,
	string[] newValues,
	bool isVertical
)

Sub Replace ( 
	oldValue As String,
	newValues As String(),
	isVertical As Boolean
)

void Replace(
	String^ oldValue, 
	array<String^>^ newValues, 
	bool isVertical
)

abstract Replace : 
oldValue : string * 
newValues : string[] * 
isVertical : bool -> unit

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.

Reference

IWorkbook Interface

Replace Overload

Spire.Xls.Core Namespace

IWorkbook AddLanguageSpecificTextSet("LSTE656118B_0?cpp=::|nu=."); Replace Method (String, AddLanguageSpecificTextSet("LSTE656118B_1?cpp=array&lt;"); String AddLanguageSpecificTextSet("LSTE656118B_2?cpp=&gt;|vb=()|nu=[]"); , Boolean)

Parameters

Reference

IWorkbook Replace Method (String, String , Boolean)