Spread for ASP.NET 7.0 Product Documentation
SheetView Property
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SpreadDataSource Class : SheetView Property


Glossary Item Box

Gets the sheet associated with this data source.

Syntax

Visual Basic (Declaration) 
Public ReadOnly Property SheetView As SheetView
Visual Basic (Usage)Copy Code
Dim instance As SpreadDataSource
Dim value As SheetView
 
value = instance.SheetView
C# 
public SheetView SheetView {get;}

Property Value

SheetView object containing the sheet

Example

This example binds a cell range.
C#Copy Code
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 BasicCopy Code
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

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.