SheetName Property (SpreadDataSource)

Gets or sets the name of the sheet associated with this data source.

Syntax

Visual Basic
C#

'Declaration
 
Public Property SheetName As String

'Usage
 
Dim instance As SpreadDataSource
Dim value As String
 
instance.SheetName = value
 
value = instance.SheetName

public string SheetName {get; set;}

Property Value

String containing the sheet name

Example

This example binds a cell range and a list box 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();

Visual Basic

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()

Reference

SpreadDataSource Class
SpreadDataSource Members