WorkbookReplace Method (String, String, Boolean)
Replaces a cell's value with a new string array.

Namespace: Aspose.Cells
Assembly: Aspose.Cells (in Aspose.Cells.dll) Version: 19.10.0.0 (19.10)
Syntax
public int Replace(
	string placeHolder,
	string[] newValues,
	bool isVertical
)

Parameters

placeHolder
Type: SystemString
Cell placeholder
newValues
Type: SystemString
String array to replace
isVertical
Type: SystemBoolean
True - Vertical, False - Horizontal

Return Value

Type: Int32
Examples
 [C#]

 Workbook workbook = new Workbook();
 ......
 string[] newValues = new string[]{"Tom", "Alice", "Jerry"};
 workbook.Replace("AnOldValue", newValues, true);

 [Visual Basic]

 Dim workbook As Workbook =  New Workbook() 
 .............
Dim NewValues() As String =  New String() {"Tom", "Alice", "Jerry"}        
workbook.Replace("AnOldValue", NewValues, True)
See Also