All docs
V21.2
21.2
21.1
20.2
20.1
19.2
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.

XlDocumentView Class

Contains display options for the workbook.

Namespace: DevExpress.Export.Xl

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

Declaration

public class XlDocumentView

The following members accept/return XlDocumentView objects:

Remarks

Use the XlDocumentView class options to 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:

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;
  }
}

Inheritance

Object
XlDocumentView
See Also