Spread Windows Forms 6.0 Product Documentation
GetArray Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > DefaultSheetDataModel Class : GetArray Method


Glossary Item Box

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.
C#Copy Code
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 BasicCopy Code
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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.