Spread Windows Forms 6.0 Product Documentation
SetArray Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > IArraySupport Interface : SetArray Method


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

Glossary Item Box

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);
Visual BasicCopy 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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

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