Spread for ASP.NET 9.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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

SheetViewCollection Class
SheetViewCollection Members

 

 


Copyright © GrapeCity, inc. All rights reserved.