Spread Property (SpreadDataSource)

Visual Basic
C#

'Declaration
 
Public ReadOnly Property Spread As FpSpread

'Usage
 
Dim instance As SpreadDataSource
Dim value As FpSpread
 
value = instance.Spread

public FpSpread Spread {get;}

Property Value

FpSpread object containing the Spread component

This example binds a cell range.

C#

FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Value = "UserName";
FpSpread1.Sheets[0].Cells[0, 0].Value = "Test";
FpSpread1.Sheets[0].Cells[1, 0].Value = "Ann";
FpSpread1.Sheets[0].Cells[2, 0].Value = "Doug";
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);
spreadDS.SheetView.BackColor = System.Drawing.Color.Pink; 
//will set backcolor of current sheetview of 
//FpSpread1 to "Pink" color
spreadDS.Spread.Sheets.Count = 3; // will set sheetview count of FpSpread1 to 3

Visual Basic

FpSpread1.Sheets(0).ColumnHeader.Cells(0, 0).value = "UserName"
FpSpread1.Sheets(0).Cells(0, 0).Value = "Test"
FpSpread1.Sheets(0).Cells(1, 0).Value = "Ann"
FpSpread1.Sheets(0).Cells(2, 0).Value = "Doug"
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)
spreadDS.SheetView.BackColor = System.Drawing.Color.Pink
spreadDS.Spread.Sheets.Count = 3

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

SpreadDataSource Class
SpreadDataSource Members