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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members
Overload List