Spread for ASP.NET 8.0 Product Documentation
Item Property (SheetViewCollection)
Example 


Gets or sets the sheet at a specific position in the collection.
Overload List
OverloadDescription
Item(Int32)Gets or sets the sheet at a specific position in the collection.  
Item(String)Gets or sets the sheet (SheetView object) at the specified position in the collection.  
Exceptions
ExceptionDescription
System.ArgumentException Sheet index must be between 0 and total number of sheets.
Remarks
The collection index is zero-based. The index of the first sheet in the collection is 0, the second is 1, etc.
Example
This example assigns a SheetView object to the first sheet, sets up 5 columns and 50 rows, removes the horizontal gridlines, and positions the page navigation on top of the spreadsheet.
FarPoint.Web.Spread.SheetViewsv=FpSpread1.Sheets[0];
sv.ColumnCount=5;
sv.PageSize=10;
sv.RowCount=50;
sv.GridLineColor=Color.Red;
sv.GridLines=GridLines.Vertical;
FpSpread1.Pager.Position=FarPoint.Web.Spread.PagerPosition.Top;
DimsvAsFarPoint.Web.Spread.SheetView
sv=FpSpread1.Sheets.Item(0)
sv.ColumnCount=5
sv.PageSize=10
sv.RowCount=50
sv.GridLineColor=Color.Red
sv.GridLines=GridLines.Vertical
FpSpread1.Pager.Position=FarPoint.Web.Spread.PagerPosition.Top
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

Reference

SheetViewCollection Class
SheetViewCollection Members

 

 


Copyright © GrapeCity, inc. All rights reserved.