Xceed Workbooks for .NET v1.4 Documentation
WorkbookView Class
Members  Example 


Xceed.Workbooks.NET Assembly > Xceed.Workbooks.NET Namespace : WorkbookView Class
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.
Syntax
'Declaration

 

Public Class WorkbookView 
'Usage

 

Dim instance As WorkbookView
public class WorkbookView 
Remarks
You can have multiple WorkbookView in a document. These 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

Reference

WorkbookView Members
Xceed.Workbooks.NET Namespace