Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / WorkbookView Class
Members Example


In This Topic
    WorkbookView Class
    In This Topic
    Represents a view displaying a single Workbook.
    Syntax
    'Declaration
     
    
    Public Class WorkbookView 
    'Usage
     
    
    Dim instance As WorkbookView
    public class WorkbookView 
    Remarks

    Each WorkbookView opens a new window when the document is opened; this allows the user to focus on an important element of the document by displaying it in a different window.

    Note that it is possible to have multiple WorkbookView in a document; they are collected in the WorkbookViewCollection.

    Example
    using( var workbook = Workbook.Create( "test.xlsx" ) )
      {
        // Get the first worksheet. A workbook contains at least 1 worksheet.
        var worksheet_A = workbook.Worksheets[ 0 ];
    
        // Fill cells in 1st worksheet.
        worksheet_A.Cells[ "D5" ].Value = "This is the first Worksheet.";
    
        // Add a worksheet with default "SheetX" name.
        var worksheet_B = workbook.Worksheets.Add();
    
        // Fill cells in 2nd worksheet.
        worksheet_B.Cells[ "D5" ].Value = "This is the second Worksheet.";
    
        // Add a worksheet with name "Third Sheet".
        var worksheet_C = workbook.Worksheets.Add( "Third Sheet" );
    
        // Fill cells in 3rd worksheet.
        worksheet_C.Cells[ "D5" ].Value = "This is the third Worksheet.";
           
        // Assign the active worksheet to be the 2nd one.
        workbook.WorkbookViews[ 0 ].ActiveTab = 1;
    
        // Save workbook to disk.
        workbook.Save();
      }
    Inheritance Hierarchy

    System.Object
       Xceed.Workbooks.NET.WorkbookView

    Requirements

    Target Platforms: Windows 11, Windows 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also