Click or drag to resize

XlsWorksheet InsertArray Method ( Double , Int32, Int32, Boolean)

Imports an array of doubles into a worksheet.
Examples
The following code illustrates how to Imports an array of Double values into a worksheet with the specified row and column:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Initialize the double Array</para><para>double[] arrayDouble = new double[4] { 344.0045, 345.0045, 346.0045, 347.0045 };</para><para>//Insert the double Array to Sheet</para><para>worksheet.InsertArray(arrayDouble, 1, 1, true);</para><para>//Save to file</para><para>workbook.SaveToFile(InsertArray.xlsx");</para>

Namespace: Spire.Xls.Core.Spreadsheet
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
public int InsertArray(
	double[] doubleArray,
	int firstRow,
	int firstColumn,
	bool isVertical
)

Parameters

doubleArray
Type: System Double
Double array
firstRow
Type: System Int32
The row number of the first cell to import in.
firstColumn
Type: System Int32
The column number of the first cell to import in.
isVertical
Type: System Boolean
Specifies to import data vertically or horizontally.

Return Value

Type: Int32

Implements

IWorksheet InsertArray( Double , Int32, Int32, Boolean)
See Also