Spread for ASP.NET 9.0 Product Documentation
SetArray Method (DefaultSheetDataModel)
Example 


Sets an object array into a specified range of cells
Overload List
OverloadDescription
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.
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

See Also

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members
GetArray

 

 


Copyright © GrapeCity, inc. All rights reserved.