Spread Windows Forms 9.0 Product Documentation
GetArray Method (DefaultSheetDataModel)
Example 


Gets an object array from a specified range of cells.
Overload List
OverloadDescription
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());
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())
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members

 

 


Copyright © GrapeCity, inc. All rights reserved.