Xceed Logo
Shop
Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / SheetView Class
Example


In This Topic
    SheetView Class
    In This Topic
    Represents a view displaying a single sheet from a Worksheet.
    Syntax
    'Declaration
 

    Public Class SheetView 
   Inherits WorksheetElement
    'Usage
 

    Dim instance As SheetView
    public class SheetView : WorksheetElement
    Remarks
    Currently, only one SheetView per Worksheet is supported.
    Example
    using( var doc = Workbook.Load( "test.xlsx") )
  {
    var worksheet = doc.Worksheets[ 0 ];        
    worksheet.SheetView.ActiveCellAddress = “C2”;
    worksheet.SheetView.TopLeftCellAddress = “B1”;
    doc.Save();
  }
    Inheritance Hierarchy

    System.Object
       Xceed.Workbooks.NET.WorkbookElement
          Xceed.Workbooks.NET.WorksheetElement
             Xceed.Workbooks.NET.SheetView

    Public Properties
     NameDescription
    Public PropertyActiveCellAddressGets or sets the active Cell in the Worksheet, which is the Cell in focus.  
    Public PropertyFrozenColumnsGets or sets the number of frozen Columns in the Worksheet.  
    Public PropertyFrozenRowsGets or sets the number of frozen Rows in the Worksheet.    
    Public PropertySplitColumnsGets or sets the number of Columns after which a vertical split will appear in the Worksheet.     
    Public PropertySplitRowsGets or sets the number of Rows after which a horizontal split will appear in the Worksheet.  
    Public PropertyTopLeftCellAddressGets or sets the Cell that will be displayed in the top left position of the SheetView.  
    Public PropertyViewTypeGets or sets the WorksheetViewType associated with the Worksheet.  
    Public PropertyZoomScale

    Gets or sets the Zoom level used when the Worksheet is displayed in Normal mode.

     
    Public PropertyZoomScalePageBreakPreview

    Gets or sets the Zoom level used when the Worksheet is displayed in PageBreakPreview mode.

     
    Public PropertyZoomScalePageLayout

    Gets or sets the Zoom level used when the Worksheet is displayed in PageLayout mode.

     
    Top
    Supported Frameworks

    .NET: net5.0, net5.0-windows, net6.0, net6.0-macos, net6.0-windows, net7.0, net7.0-macos, net7.0-windows, net8.0, net8.0-browser, net8.0-macos, net8.0-windows, net9.0, net9.0-browser, net9.0-macos, net9.0-windows, net10.0, net10.0-browser, net10.0-macos, net10.0-windows.

    .NET Framework: net40, net403, net45, net451, net452, net46, net461, net462, net463, net47, net471, net472, net48, net481.

    See Also

    Reference

    SheetView Members
    Xceed.Workbooks.NET Namespace

    Send Feedback