SetArray Method
Applies To
fpSpread control
Description
Sets an array of data into the sheet.
Syntax
BOOL CSpreadSheet::SetArray(long ColLeft, long RowTop, const VARIANT& VarArray);
fpSpread.SetArray(ByVal ColLeft As Long, ByVal RowTop As Long, ByVal VarArray As Variant) As Boolean
Parameters
The following parameters are available:
| Parameter | Description |
| ColLeft | Specifies the column of the cell at which to start adding the data from the array |
| RowTop | Specifies the row of the cell at which to start adding the data from the array |
| VarArray | Array that contains the data to add to the sheet |
Remarks
Use the SetArray method to add data to the sheet from an array.
Before you call the method, you must declare the array as the type of array needed to contain the data to be added to the sheet.
This method is called for the current sheet setting unless you first set the Sheet property to specify the sheet with which you want to work. Specify the cell at which to start adding data using the ColLeft and RowTop parameters. The control adds data into the sheet starting at the specified cell, proceeding left to right and top to bottom.
Return Type
True if successful; otherwise, False.
See Also
Sheet property
GetArray method
DLL Correspondence
SSSetArray function