Spread for ASP.NET 9.0 Product Documentation
GetArray Method (IArraySupport)
Example 


Starting model row index
Starting model column index
Number of rows to copy
Number of columns to copy
Gets an object array from a specified range of cells.
Syntax
'Declaration
 
Function GetArray( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer _
) As Object(,)
'Usage
 
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)
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] that contains tabular data
Example
This example sets an array into the model.
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());
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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

IArraySupport Interface
IArraySupport Members

 

 


Copyright © GrapeCity, inc. All rights reserved.