Spread Windows Forms 7.0 Product Documentation
SetArray Method
See Also Example Support Options

FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > IArraySupport Interface : SetArray Method

Visual Basic (Declaration)
Visual Basic (Usage)
C#

row: Starting model row index

column: Starting model column index

value: Two-dimensional object array[row,column] containing tabular data

Sets an object array into a specified range of cells.

Syntax

Visual Basic (Declaration)
Sub SetArray( _ ByVal row As Integer, _ ByVal column As Integer, _ ByVal value(,) As Object _ )

Visual Basic (Usage)	Copy Code
Dim instance As IArraySupport Dim row As Integer Dim column As Integer Dim value() As Object instance.SetArray(row, column, value)

C#
void SetArray( int row, int column, object[,] value )

Parameters

row: Starting model row index
column: Starting model column index
value: Two-dimensional object array[row,column] containing tabular data

Example

This example sets an array into the data model.

C#	Copy Code
FarPoint.Win.Spread.Model.IArraySupport ias; ias = (FarPoint.Win.Spread.Model.IArraySupport)fpSpread1.ActiveSheet.Models.Data; object[,] x = {{6.0, 5.0, 11.0, 7.0, 5.0, 4.0, 4.0}}; ias.SetArray(0, 0, x);

Copy Code

FarPoint.Win.Spread.Model.IArraySupport ias;
ias = (FarPoint.Win.Spread.Model.IArraySupport)fpSpread1.ActiveSheet.Models.Data;
object[,] x = {{6.0, 5.0, 11.0, 7.0, 5.0, 4.0, 4.0}};
ias.SetArray(0, 0, x);

Visual Basic	Copy Code
Dim ias As FarPoint.Win.Spread.Model.IArraySupport ias = FpSpread1.ActiveSheet.Models.Data Dim x As Object(,) = {{2.0, 3.0, 9.0, 1.0, 8.0, 7.0, 5.0}} ias.SetArray(0, 0, x)

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Syntax

Parameters

Example

Requirements

See Also

Reference