GetArray(Int32,Int32,Int32,Int32,Boolean) Method

Visual Basic
C#

'Declaration
 
Public Overloads Function GetArray( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer, _
   ByVal formula As Boolean _
) As Object(,)

'Usage
 
Dim instance As DefaultSheetDataModel
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
Dim formula As Boolean
Dim value() As Object
 
value = instance.GetArray(row, column, rowCount, columnCount, formula)

public object[,] GetArray( 
   int row,
   int column,
   int rowCount,
   int columnCount,
   bool formula
)

Parameters

row: Row index of the cell from which to read into the array
column: Column index of the cell from which to read into the array
rowCount: Number of rows in the array
columnCount: Number of columns in the array
formula: If true, return formulas; otherwise, return values.

This example uses the Formula parameter.

C#

FarPoint.Web.Spread.Model.DefaultSheetDataModel dm = (FarPoint.Web.Spread.Model.DefaultSheetDataModel)FpSpread1.ActiveSheetView.DataModel;
object[,] arr;
arr = dm.GetArray(0, 0, 2, 2, true);
ListBox1.Items.Add(Convert.ToString(arr.GetLowerBound(1)));

Visual Basic

Dim dm As FarPoint.Web.Spread.Model.DefaultSheetDataModel = CType(FpSpread1.ActiveSheetView.DataModel, FarPoint.Web.Spread.Model.DefaultSheetDataModel)
Dim arr(,) As Object
arr = dm.GetArray(0, 0, 2, 2, True)
ListBox1.Items.Add(Convert.ToString(arr.GetLowerBound(1)))

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

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members
Overload List