Spread for ASP.NET 9.0 Product Documentation
CellRange Property (SpreadDataSource)
Example 


Gets or sets the range of cells for this data source.
Syntax
'Declaration
 
Public Property CellRange As CellRange
'Usage
 
Dim instance As SpreadDataSource
Dim value As CellRange
 
instance.CellRange = value
 
value = instance.CellRange
public CellRange CellRange {get; set;}

Property Value

CellRange containing the range of cells
Example
This example binds a cell range and a listbox to the Spread data source.
FpSpread1.DataSource = AccessDataSource1;
FarPoint.Web.Spread.SpreadDataSource spreadDS = new FarPoint.Web.Spread.SpreadDataSource();
spreadDS.SheetName = FpSpread1.ActiveSheetView.SheetName;
spreadDS.SpreadID = "FpSpread1";//FpSpread1.ID;
spreadDS.CellRange = new FarPoint.Web.Spread.Model.CellRange(0, 0, 3, 1);
this.Controls.Add(spreadDS);
this.ListBox1.DataSource = spreadDS;
this.ListBox1.DataTextField = "UserName";
this.ListBox1.DataBind();

FpSpread1.DataSource = AccessDataSource1
Dim spreadDS As New FarPoint.Web.Spread.SpreadDataSource()
spreadDS.SheetName = FpSpread1.ActiveSheetView.SheetName
spreadDS.SpreadID = "FpSpread1"
spreadDS.CellRange = New FarPoint.Web.Spread.Model.CellRange(0, 0, 3, 1)
Controls.Add(spreadDS)
ListBox1.DataSource = spreadDS
ListBox1.DataTextField = "UserName"
ListBox1.DataBind()
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

SpreadDataSource Class
SpreadDataSource Members

 

 


Copyright © GrapeCity, inc. All rights reserved.