Gets or sets the sheet at a specific position in the collection.
Overload List
| Overload | Description |
|---|
| 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
Remarks
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.
| C# |  Copy Code |
|---|
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; |
| Visual Basic | Copy Code |
|---|
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
