Spread ASP.NET 6.0 Product Documentation
SheetView Property
See Also  Example Send Feedback
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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2002-2012 GrapeCity, Inc. All Rights Reserved.