Spread for ASP.NET 7.0 Product Documentation
GetArray Method
See Also Example Support Options

FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > IArraySupport Interface : GetArray Method

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

row: Starting model row index

column: Starting model column index

rowCount: Number of rows to copy

columnCount: Number of columns to copy

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)

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

This example sets an array into the model.

C#	Copy Code
FarPoint.Web.Spread.Model.IArraySupport ias; ias = (FarPoint.Web.Spread.Model.IArraySupport)FpSpread1.ActiveSheetView.DataModel; 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); Response.Write("The last column in the array is " + arr.GetUpperBound(1).ToString());

Copy Code

FarPoint.Web.Spread.Model.IArraySupport ias;
ias = (FarPoint.Web.Spread.Model.IArraySupport)FpSpread1.ActiveSheetView.DataModel;
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);
Response.Write("The last column in the array is " + arr.GetUpperBound(1).ToString());

Visual Basic	Copy Code
Dim ias As FarPoint.Web.Spread.Model.IArraySupport ias = FpSpread1.ActiveSheetView.DataModel 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) Response.Write("The last column in the array is " & arr.GetUpperBound(1).ToString())

Visual Basic

Copy Code

Dim ias As FarPoint.Web.Spread.Model.IArraySupport
ias = FpSpread1.ActiveSheetView.DataModel
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)
Response.Write("The last column in the array is " & arr.GetUpperBound(1).ToString())

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Syntax

Parameters

Return Value

Example

Requirements

See Also

Reference