IXlDocument.View Property

Provides access to the view options of the workbook.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v19.2.Core.dll

Declaration

C#

XlDocumentView View { get; }

VB.NET

ReadOnly Property View As XlDocumentView

Property Value

Type	Description
XlDocumentView	An object that contains view options.

Remarks

Use the View property to access and specify the workbook’s display options. These options are in effect when the document is saved and opened in Microsoft Excel.

The code sample below shows how to specify the XlDocumentView options:

C#

IXlExporter exporter = XlExport.CreateExporter(XlDocumentFormat.Xlsx);

// Create the FileStream object with the specified file path. 
using (FileStream stream = new FileStream("Document.xlsx", FileMode.Create, FileAccess.ReadWrite))
{
  // Create a new document and write it to the specified stream.
  using (IXlDocument document = exporter.CreateDocument(stream))
  {
      // Specify the document culture.
      document.Options.Culture = CultureInfo.CurrentCulture;

      //Specify display options for the created document.
      XlDocumentView workbookView = document.View;
      workbookView.GroupDatesInAutoFilterMenu = true;
      workbookView.SelectedTabIndex = 1;
      workbookView.ShowSheetTabs = false;
      workbookView.ShowVerticalScrollBar = false;
  }
}

VB.NET

Dim exporter As IXlExporter = XlExport.CreateExporter(XlDocumentFormat.Xlsx)

' Create the FileStream object with the specified file path. 
Using stream As New FileStream("Document.xlsx", FileMode.Create, FileAccess.ReadWrite)
  ' Create a new document and write it to the specified stream.
  Using document As IXlDocument = exporter.CreateDocument(stream)
    ' Specify the document culture.
    document.Options.Culture = CultureInfo.CurrentCulture

    'Specify display options for the created document.
    Dim workbookView As XlDocumentView = document.View
    workbookView.GroupDatesInAutoFilterMenu = True
    workbookView.SelectedTabIndex = 1
    workbookView.ShowSheetTabs = False
    workbookView.ShowVerticalScrollBar = False
  End Using
End Using