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


row
Starting model row index
column
Starting model column index
rowCount
Number of rows to copy
columnCount
Number of columns to copy

Glossary Item Box

Gets an object array from a specified range of cells.

Syntax

Visual Basic (Declaration) 
Function GetArray( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer _
) As Object(,)
Visual Basic (Usage)Copy Code
Dim instance As IArraySupport
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
Dim value() As Object
 
value = instance.GetArray(row, column, rowCount, columnCount)
C# 
object[,] GetArray( 
   int row,
   int column,
   int rowCount,
   int columnCount
)

Parameters

row
Starting model row index
column
Starting model column index
rowCount
Number of rows to copy
columnCount
Number of columns to copy

Return Value

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

Example

FarPoint.Win.Spread.Model.IArraySupport.GetArray
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);
object[,] arr;
arr = ias.GetArray(0, 0, 1, 7);
MessageBox.Show("The last column in the array is " + arr.GetUpperBound(1).ToString());
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)

Dim arr(,) As Object
arr = ias.GetArray(0, 0, 1, 7)
MessageBox.Show("The last column in the array is " & arr.GetUpperBound(1).ToString())

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.