SetArray Method (DefaultSheetDataModel)

Sets an object array into a specified range of cells

Overload List

Overload	Description
SetArray(Int32,Int32,Object[,])	Sets an object array into a specified range of cells.
SetArray(Int32,Int32,Object[,],Boolean)	Sets an object array into a specified range of cells.

Remarks

Sets an object array into a specified range of cells

Example

This example creates a new DefaultSheetDataModel and attaches it to the DataModel of the active sheet. Data is added via the SetArray method.

Visual Basic

Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles MyBase.Load

If(Me.IsPostBack)Then Return

Dim dm As New FarPoint.Web.Spread.Model.DefaultSheetDataModel(8,8)
FpSpread1.ActiveSheetView.DataModel=dm

Dim arr(4,9) As Object
Dim o As Object
Dim i,j As Integer
For i=0 To 4
For j=0 To 9
arr(i,j)=i+j
Next j
Next i
dm.SetArray(1,0,arr)
End Sub

private void Page_Load(object sender,System.EventArgs e)
{
if(this.IsPostBack)return;

FarPoint.Web.Spread.Model.DefaultSheetDataModel dm=new FarPoint.Web.Spread.Model.DefaultSheetDataModel(10,10);
FpSpread1.ActiveSheetView.DataModel=dm;

int i,j;
object[,]arr;
arr=new object[4,9];
for(i=0;i<4;i++)
{
for(j=0;j<9;j++)
arr[i,j]=i+j;
}
dm.SetArray(1,0,arr);
}

Requirements

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
GetArray