WorkbookReplace Method (String, Int32, Boolean)
Replaces cells' values with an integer array.

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

Parameters

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

Return Value

Type: Int32
Examples
 [C#]

 Workbook workbook = new Workbook();
 ......
 int[] newValues = new int[]{1, 2, 3};
 workbook.Replace("AnOldValue", newValues, true);

 [Visual Basic]

 Dim workbook As Workbook =  New Workbook() 
...........
Dim NewValues() As Integer =  New Integer() {1, 2, 3}
workbook.Replace("AnOldValue", NewValues, True)
See Also