WorkbookReplace Method (String, Double, Boolean)
Replaces cells' values with a double array.

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

Parameters

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

Return Value

Type: Int32
Examples
[C#]

Workbook workbook = new Workbook();
......
double[] newValues = new double[]{1.23, 2.56, 3.14159};
workbook.Replace("AnOldValue", newValues, true);

[Visual Basic]

Dim workbook As Workbook =  New Workbook() 
...........
Dim NewValues() As Double =  New Double() {1.23, 2.56, 3.14159}
workbook.Replace("AnOldValue", NewValues, True)
See Also