Spread 8.0 Documentation
SetArray Method
Support Options
ActiveX Reference > ActiveX Methods > SetArray Method

Glossary Item Box

SetArray Method


See Also    DLL    Example

Applies To

fpSpread control

Description

Sets an array of data into the sheet.

Syntax

C++

BOOL CSpreadSheet::SetArray(long ColLeft, long RowTop, const VARIANT& VarArray);

Visual Basic

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

Adding Data

Sheet property

GetArray method

DLL Correspondence

SSSetArray function

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.