Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetViewCollection Class / Item Property
Example


In This Topic
    Item Property (SheetViewCollection)
    In This Topic
    Gets or sets the sheet at a specific position in the collection.
    Overload List
    OverloadDescription
    Gets or sets the sheet at a specific position in the collection.  
    Gets or sets the sheet (SheetView object) at the specified position in the collection.  
    Exceptions
    ExceptionDescription
    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
    See Also