GetArray Method (DefaultSheetDataModel)

Gets an object array from a specified range of cells.

Overload List

Overload	Description
GetArray(Int32,Int32,Int32,Int32)	Gets an object array from a specified range of cells.
GetArray(Int32,Int32,Int32,Int32,Boolean)	Gets an object array from a specified range of cells.

Remarks

This method returns a two-dimensional array (row,column).

Example

This example gets an array object from a range of cells.

FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5);
object[,] arr;
fpSpread1.ActiveSheet.Models.Data = dataModel;
arr = dataModel.GetArray(0, 0, 2, 2);
listBox1.Items.Add(arr.GetLowerBound(1).ToString());

Visual Basic

Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5)
Dim arr(,) As Object
FpSpread1.ActiveSheet.Models.Data = dataModel
arr = dataModel.GetArray(0, 0, 2, 2)
ListBox1.Items.Add(arr.GetLowerBound(1).ToString())

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members