Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Expand]Controls and Libraries
 [Expand]Common Features
  Get More Help
 [Collapse]API Reference
  [Expand]DevExpress.DataAccess.UI.Design
  [Expand]DevExpress.DataAccess.UI.EntityFramework
  [Expand]DevExpress.DataAccess.UI.Excel
  [Expand]DevExpress.DataAccess.UI.Localization
  [Expand]DevExpress.DataAccess.UI.ObjectBinding
  [Expand]DevExpress.DataAccess.UI.Sql
  [Expand]DevExpress.DataAccess.UI.Wizard
  [Expand]DevExpress.DataAccess.UI.Wizard.Services
  [Expand]DevExpress.DataAccess.UI.Wizard.Views
  [Expand]DevExpress.DocumentView
  [Expand]DevExpress.DocumentView.Controls
  [Expand]DevExpress.LookAndFeel
  [Expand]DevExpress.LookAndFeel.Helpers
  [Expand]DevExpress.Skins
  [Expand]DevExpress.Snap
  [Expand]DevExpress.Snap.API.Native
  [Expand]DevExpress.Snap.Core
  [Expand]DevExpress.Snap.Core.API
  [Expand]DevExpress.Snap.Core.Fields
  [Expand]DevExpress.Snap.Core.Forms
  [Expand]DevExpress.Snap.Core.Options
  [Expand]DevExpress.Snap.Core.Services
  [Expand]DevExpress.Snap.Extensions
  [Expand]DevExpress.Snap.Extensions.Localization
  [Expand]DevExpress.Snap.Extensions.UI
  [Expand]DevExpress.Snap.Localization
  [Expand]DevExpress.Snap.Options
  [Expand]DevExpress.Snap.Services
  [Expand]DevExpress.Utils
  [Expand]DevExpress.Utils.Animation
  [Expand]DevExpress.Utils.Controls
  [Expand]DevExpress.Utils.Drawing
  [Expand]DevExpress.Utils.Menu
  [Expand]DevExpress.Utils.Taskbar
  [Expand]DevExpress.Utils.Taskbar.Core
  [Expand]DevExpress.Utils.UI.Localization
  [Expand]DevExpress.Utils.VisualEffects
  [Expand]DevExpress.Utils.Win
  [Expand]DevExpress.XtraBars
  [Expand]DevExpress.XtraBars.Alerter
  [Expand]DevExpress.XtraBars.Docking
  [Expand]DevExpress.XtraBars.Docking2010
  [Expand]DevExpress.XtraBars.Docking2010.Customization
  [Expand]DevExpress.XtraBars.Docking2010.Views
  [Expand]DevExpress.XtraBars.Docking2010.Views.NativeMdi
  [Expand]DevExpress.XtraBars.Docking2010.Views.Tabbed
  [Expand]DevExpress.XtraBars.Docking2010.Views.Widget
  [Expand]DevExpress.XtraBars.Docking2010.Views.WindowsUI
  [Expand]DevExpress.XtraBars.Localization
  [Expand]DevExpress.XtraBars.Navigation
  [Expand]DevExpress.XtraBars.Ribbon
  [Expand]DevExpress.XtraBars.Ribbon.Gallery
  [Expand]DevExpress.XtraBars.Ribbon.ViewInfo
  [Expand]DevExpress.XtraBars.ToastNotifications
  [Expand]DevExpress.XtraBars.Utils
  [Expand]DevExpress.XtraBars.WinRTLiveTiles
  [Expand]DevExpress.XtraCharts
  [Expand]DevExpress.XtraCharts.Designer
  [Expand]DevExpress.XtraCharts.Wizard
  [Expand]DevExpress.XtraDataLayout
  [Expand]DevExpress.XtraDiagram
  [Expand]DevExpress.XtraDiagram.Options
  [Expand]DevExpress.XtraEditors
  [Expand]DevExpress.XtraEditors.ButtonPanel
  [Expand]DevExpress.XtraEditors.Calendar
  [Expand]DevExpress.XtraEditors.Camera
  [Expand]DevExpress.XtraEditors.Container
  [Expand]DevExpress.XtraEditors.Controls
  [Expand]DevExpress.XtraEditors.CustomEditor
  [Expand]DevExpress.XtraEditors.DXErrorProvider
  [Expand]DevExpress.XtraEditors.Filtering
  [Expand]DevExpress.XtraEditors.Mask
  [Expand]DevExpress.XtraEditors.Persistent
  [Expand]DevExpress.XtraEditors.Repository
  [Expand]DevExpress.XtraEditors.ViewInfo
  [Expand]DevExpress.XtraFilterEditor
  [Expand]DevExpress.XtraGauges.Presets.Styles
  [Expand]DevExpress.XtraGauges.Win
  [Expand]DevExpress.XtraGauges.Win.Base
  [Expand]DevExpress.XtraGauges.Win.Gauges.Circular
  [Expand]DevExpress.XtraGauges.Win.Gauges.Digital
  [Expand]DevExpress.XtraGauges.Win.Gauges.Linear
  [Expand]DevExpress.XtraGauges.Win.Gauges.State
  [Expand]DevExpress.XtraGrid
  [Expand]DevExpress.XtraGrid.Columns
  [Expand]DevExpress.XtraGrid.EditForm
  [Expand]DevExpress.XtraGrid.FilterEditor
  [Expand]DevExpress.XtraGrid.Localization
  [Expand]DevExpress.XtraGrid.Views.BandedGrid
  [Expand]DevExpress.XtraGrid.Views.BandedGrid.ViewInfo
  [Expand]DevExpress.XtraGrid.Views.Base
  [Expand]DevExpress.XtraGrid.Views.Base.ViewInfo
  [Expand]DevExpress.XtraGrid.Views.Card
  [Expand]DevExpress.XtraGrid.Views.Card.ViewInfo
  [Expand]DevExpress.XtraGrid.Views.Grid
  [Expand]DevExpress.XtraGrid.Views.Grid.ViewInfo
  [Expand]DevExpress.XtraGrid.Views.Layout
  [Expand]DevExpress.XtraGrid.Views.Layout.Events
  [Expand]DevExpress.XtraGrid.Views.Layout.ViewInfo
  [Expand]DevExpress.XtraGrid.Views.Printing
  [Expand]DevExpress.XtraGrid.Views.Tile
  [Expand]DevExpress.XtraGrid.Views.WinExplorer
  [Expand]DevExpress.XtraGrid.WinExplorer
  [Expand]DevExpress.XtraLayout
  [Expand]DevExpress.XtraLayout.Customization
  [Expand]DevExpress.XtraLayout.HitInfo
  [Expand]DevExpress.XtraLayout.Localization
  [Expand]DevExpress.XtraLayout.Utils
  [Expand]DevExpress.XtraMap
  [Expand]DevExpress.XtraMap.Printing
  [Expand]DevExpress.XtraNavBar
  [Expand]DevExpress.XtraNavBar.ViewInfo
  [Expand]DevExpress.XtraPdfViewer
  [Expand]DevExpress.XtraPdfViewer.Commands
  [Expand]DevExpress.XtraPdfViewer.Localization
  [Collapse]DevExpress.XtraPivotGrid
   [Expand]CancelPivotCellEditEventArgs Class
   [Expand]CustomCustomizationFormSortEventArgs Class
   [Expand]CustomEditValueEventArgs Class
    CustomEditValueEventHandler Delegate
   [Expand]CustomExportCellEventArgs Class
   [Expand]CustomExportFieldValueEventArgs Class
   [Expand]CustomExportHeaderEventArgs Class
   [Expand]CustomFieldDataEventArgs Class
    CustomFieldDataEventHandler Delegate
   [Expand]CustomizationFormShowingEventArgs Class
    CustomizationFormShowingEventHandler Delegate
   [Expand]CustomizePivotCellEventArgs Class
    CustomizePivotCellEventHandler Delegate
   [Expand]CustomServerModeSortEventArgs Class
   [Expand]EditValueChangedEventArgs Class
    EditValueChangedEventHandler Delegate
    ExcelFilterDateTimeValuesTabFilterType Enumeration
    ExcelFilterDefaultTab Enumeration
    ExcelFilterEnumFilters Enumeration
    ExcelFilterNumericValuesTabFilterType Enumeration
    ExcelFilterTextFilters Enumeration
    FieldFilterPopupMode Enumeration
   [Expand]FieldValueCell Class
   [Expand]FilterPopupExcelCustomizeTemplateEventArgs Class
    FilterPopupExcelCustomizeTemplateEventHandler Delegate
   [Expand]FilterPopupExcelDataEventArgs Class
    FilterPopupExcelDataEventHandler Delegate
   [Expand]FilterPopupExcelEventArgs Class
    FilterPopupExcelEventHandler Delegate
   [Expand]FilterPopupExcelPrepareTemplateEventArgs Class
    FilterPopupExcelPrepareTemplateEventHandler Delegate
   [Expand]FilterPopupExcelQueryFilterCriteriaEventArgs Class
    FilterPopupExcelQueryFilterCriteriaEventHandler Delegate
    FilterPopupToolbarButtons Enumeration
   [Expand]FormatRuleFieldIntersectionSettings Class
   [Expand]FormatRuleSettings Class
   [Expand]FormatRuleTotalTypeSettings Class
   [Expand]PivotAreaChangingEventArgs Class
    PivotAreaChangingEventHandler Delegate
   [Expand]PivotCellBaseEventArgs Class
   [Expand]PivotCellDisplayTextEventArgs Class
    PivotCellDisplayTextEventHandler Delegate
   [Expand]PivotCellEditEventArgs Class
   [Expand]PivotCellEventArgs Class
    PivotCellEventHandler Delegate
   [Expand]PivotCellValueEventArgs Class
   [Expand]PivotContextMenuIds Class
   [Expand]PivotCustomAppearanceEventArgs Class
    PivotCustomAppearanceEventHandler Delegate
   [Expand]PivotCustomAppearanceThreadSafeEventArgs Class
   [Expand]PivotCustomCellEditEventArgs Class
   [Expand]PivotCustomChartDataSourceDataEventArgs Class
    PivotCustomChartDataSourceDataEventHandler Delegate
   [Expand]PivotCustomChartDataSourceRowsEventArgs Class
    PivotCustomChartDataSourceRowsEventHandler Delegate
   [Expand]PivotCustomColumnWidthEventArgs Class
   [Expand]PivotCustomDrawBaseThreadSafeEventArgs Class
   [Expand]PivotCustomDrawCellBaseEventArgs Class
   [Expand]PivotCustomDrawCellBaseThreadSafeEventArgs Class
   [Expand]PivotCustomDrawCellEventArgs Class
    PivotCustomDrawCellEventHandler Delegate
   [Expand]PivotCustomDrawCellThreadSafeEventArgs Class
   [Expand]PivotCustomDrawEventArgs Class
    PivotCustomDrawEventHandler Delegate
   [Expand]PivotCustomDrawFieldHeaderEventArgs Class
    PivotCustomDrawFieldHeaderEventHandler Delegate
   [Expand]PivotCustomDrawFieldHeaderThreadSafeEventArgs Class
   [Expand]PivotCustomDrawFieldValueEventArgs Class
    PivotCustomDrawFieldValueEventHandler Delegate
   [Expand]PivotCustomDrawFieldValueThreadSafeEventArgs Class
   [Expand]PivotCustomDrawHeaderAreaEventArgs Class
    PivotCustomDrawHeaderAreaEventHandler Delegate
   [Expand]PivotCustomDrawHeaderAreaThreadSafeEventArgs Class
   [Expand]PivotCustomDrawThreadSafeEventArgs Class
   [Expand]PivotCustomFieldValueCellsEventArgs Class
    PivotCustomFieldValueCellsEventHandler Delegate
   [Expand]PivotCustomFilterPopupItemsEventArgs Class
    PivotCustomFilterPopupItemsEventHandler Delegate
   [Expand]PivotCustomGroupIntervalEventArgs Class
    PivotCustomGroupIntervalEventHandler Delegate
   [Expand]PivotCustomRowHeightEventArgs Class
    PivotEndUpdateMode Enumeration
   [Expand]PivotFieldDisplayTextEventArgs Class
    PivotFieldDisplayTextEventHandler Delegate
   [Expand]PivotFieldEventArgs Class
    PivotFieldEventHandler Delegate
   [Expand]PivotFieldFilterChangingEventArgs Class
    PivotFieldFilterChangingEventHandler Delegate
   [Expand]PivotFieldImageIndexEventArgs Class
    PivotFieldImageIndexEventHandler Delegate
   [Expand]PivotFieldImageIndexThreadSafeEventArgs Class
   [Expand]PivotFieldPropertyChangedEventArgs Class
    PivotFieldPropertyChangedEventHandler Delegate
   [Expand]PivotFieldTooltipShowingEventArgs Class
    PivotFieldTooltipShowingEventHandler Delegate
   [Expand]PivotFieldValueCancelEventArgs Class
    PivotFieldValueCancelEventHandler Delegate
   [Expand]PivotFieldValueEventArgs Class
    PivotFieldValueEventHandler Delegate
   [Expand]PivotFieldValueHitInfo Class
   [Expand]PivotFilter Class
   [Expand]PivotGridAppearances Class
   [Expand]PivotGridAppearancesBase Class
   [Expand]PivotGridAppearancesPrint Class
   [Expand]PivotGridCells Class
   [Expand]PivotGridControl Class
   [Expand]PivotGridCustomFieldSortEventArgs Class
    PivotGridCustomFieldSortEventHandler Delegate
   [Expand]PivotGridCustomSummaryEventArgs Class
    PivotGridCustomSummaryEventHandler Delegate
   [Expand]PivotGridCustomTotal Class
   [Expand]PivotGridCustomTotalCollection Class
   [Expand]PivotGridField Class
   [Expand]PivotGridFieldAppearances Class
   [Expand]PivotGridFieldCollection Class
   [Expand]PivotGridFieldImageOptions Class
   [Expand]PivotGridFieldOptionsEx Class
   [Expand]PivotGridFieldOptionsFilter Class
   [Expand]PivotGridFieldToolTips Class
   [Expand]PivotGridFormatConditionCollection Class
   [Expand]PivotGridFormatRule Class
   [Expand]PivotGridFormatRuleCollection Class
    PivotGridHeaderHitTest Enumeration
   [Expand]PivotGridHeadersAreaHitInfo Class
   [Expand]PivotGridHitInfo Class
    PivotGridHitTest Enumeration
   [Expand]PivotGridMenuEventArgs Class
   [Expand]PivotGridMenuEventArgsBase Class
    PivotGridMenuEventHandler Delegate
   [Expand]PivotGridMenuItemClickEventArgs Class
   [Expand]PivotGridMenuItemClickEventArgsBase Class
    PivotGridMenuItemClickEventHandler Delegate
    PivotGridMenuType Enumeration
   [Expand]PivotGridOptionsBehavior Class
   [Expand]PivotGridOptionsCustomizationEx Class
   [Expand]PivotGridOptionsFilterPopup Class
   [Expand]PivotGridOptionsHint Class
   [Expand]PivotGridOptionsMenu Class
   [Expand]PivotGridOptionsView Class
    PivotGridScrolling Enumeration
   [Expand]PivotGridStyleFormatCondition Class
    PivotGridValueHitTest Enumeration
   [Expand]PivotGroupEventArgs Class
    PivotGroupEventHandler Delegate
   [Expand]PivotLeftTopCellChangedEventArgs Class
   [Expand]PivotOlapExceptionEventArgs Class
    PivotOlapExceptionEventHandler Delegate
   [Expand]PivotQueryExceptionEventArgs Class
    PivotQueryExceptionEventHandler Delegate
    PivotShowButtonModeEnum Enumeration
   [Expand]PivotUserActionEventArgs Class
    PivotUserActionEventHandler Delegate
   [Collapse]PivotXlsExportOptions Class
     PivotXlsExportOptions Members
    [Expand]PivotXlsExportOptions Constructor
    [Expand]PivotXlsExportOptions Events
   [Expand]PivotXlsxExportOptions Class
   [Expand]PopupMenuShowingEventArgs Class
    PopupMenuShowingEventHandler Delegate
   [Expand]Prefilter Class
    UserAction Enumeration
  [Expand]DevExpress.XtraPivotGrid.Data
  [Expand]DevExpress.XtraPrinting
  [Expand]DevExpress.XtraPrinting.Control
  [Expand]DevExpress.XtraPrinting.Preview
  [Expand]DevExpress.XtraPrintingLinks
  [Expand]DevExpress.XtraReports.UI
  [Expand]DevExpress.XtraRichEdit
  [Expand]DevExpress.XtraRichEdit.Commands
  [Expand]DevExpress.XtraRichEdit.Export
  [Expand]DevExpress.XtraRichEdit.Import
  [Expand]DevExpress.XtraRichEdit.Localization
  [Expand]DevExpress.XtraRichEdit.Menu
  [Expand]DevExpress.XtraScheduler
  [Expand]DevExpress.XtraScheduler.Drawing
  [Expand]DevExpress.XtraScheduler.Printing
  [Expand]DevExpress.XtraScheduler.Reporting
  [Expand]DevExpress.XtraScheduler.Reporting.UI
  [Expand]DevExpress.XtraScheduler.Services
  [Expand]DevExpress.XtraScheduler.Services.Implementation
  [Expand]DevExpress.XtraScheduler.UI
  [Expand]DevExpress.XtraSpellChecker
  [Expand]DevExpress.XtraSpellChecker.Localization
  [Expand]DevExpress.XtraSplashForm
  [Expand]DevExpress.XtraSplashScreen
  [Expand]DevExpress.XtraSpreadsheet
  [Expand]DevExpress.XtraSpreadsheet.Services
  [Expand]DevExpress.XtraTab
  [Expand]DevExpress.XtraTab.Buttons
  [Expand]DevExpress.XtraTab.ViewInfo
  [Expand]DevExpress.XtraTabbedMdi
  [Expand]DevExpress.XtraToolbox
  [Expand]DevExpress.XtraTreeList
  [Expand]DevExpress.XtraTreeList.Columns
  [Expand]DevExpress.XtraTreeList.Data
  [Expand]DevExpress.XtraTreeList.Localization
  [Expand]DevExpress.XtraTreeList.Menu
  [Expand]DevExpress.XtraTreeList.Nodes
  [Expand]DevExpress.XtraTreeList.Nodes.Operations
  [Expand]DevExpress.XtraTreeList.StyleFormatConditions
  [Expand]DevExpress.XtraTreeMap
  [Expand]DevExpress.XtraVerticalGrid
  [Expand]DevExpress.XtraVerticalGrid.Events
  [Expand]DevExpress.XtraVerticalGrid.Localization
  [Expand]DevExpress.XtraVerticalGrid.Rows
  [Expand]DevExpress.XtraWaitForm
  [Expand]DevExpress.XtraWizard
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

PivotXlsExportOptions Members

Contains Pivot Grid options that define how a document is exported to XLS format in the data-aware export mode.

Expanded Public Constructors

Show: Inherited
  Name Description
Public method PivotXlsExportOptions Overloaded. Initializes a new instance of the PivotXlsExportOptions class with default settings.
Top

Expanded Public Properties

Show: Inherited
  Name Description
Public property AllowBandHeaderCellMerge Gets or sets whether cell merging is enabled for band headers in the exported document. (Inherited from XlsExportOptionsEx)
Public property AllowCellMerge Gets or sets whether cell merging is enabled in the exported document. (Inherited from XlsExportOptionsEx)
Public property AllowCombinedBandAndColumnHeaderCellMerge (Inherited from XlsExportOptionsEx)
Public property AllowConditionalFormatting Gets or sets whether conditional formatting rules applied to columns are preserved in the exported document. (Inherited from XlsExportOptionsEx)
Public property AllowFixedColumnHeaderPanel Gets or sets whether the column header panel is anchored to the top of the export document, and thus is not scrolled vertically. (Inherited from XlsExportOptionsEx)
Public property AllowFixedColumns Gets or sets whether left fixed columns enabled in a grid control are fixed in the exported document. (Inherited from XlsExportOptionsEx)
Public property AllowGrouping Gets or sets whether data groups are exported from the source control to the output document. (Inherited from XlsExportOptionsEx)
Public property AllowHyperLinks Gets or sets whether hyperlinks are exported. (Inherited from XlsExportOptionsEx)
Public property AllowLookupValues Gets or sets whether lookup values of combo-box and lookup columns are exported. (Inherited from XlsExportOptionsEx)
Public property AllowSortingAndFiltering Gets or sets whether the sorting and filtering functionality is enabled for columns in the exported document. (Inherited from XlsExportOptionsEx)
Public property AllowSparklines Gets or sets whether sparklines are exported. (Inherited from XlsExportOptionsEx)
Public property ApplyFormattingToEntireColumn Gets or sets whether cell formatting (cell appearance and borders) is applied to entire sheet columns (faster) or to individual sheet cells within the range of exported rows (slower). (Inherited from XlsExportOptionsEx)
Public property BandedLayoutMode Gets or sets how bands and columns are arranged in the output worksheet (when exporting from Banded Views). (Inherited from XlsExportOptionsEx)
Public property DocumentCulture Gets or sets the export document's culture, which defines the formatting settings for numeric and date-time data. (Inherited from XlsExportOptionsEx)
Public property DocumentOptions Provides access to options to be embedded as Document Properties of the resulting XLS file. (Inherited from XlExportOptionsBase)
Public property EncryptionOptions Provides access to the Excel file encryption options. (Inherited from XlExportOptionsBase)
Public property ExportColumnAreaHeaders Gets or sets whether to include the column field headers to the XLS exported document. (Inherited from PivotXlsExportOptionsBase)
Public property ExportDataAreaHeaders Gets or sets whether to include the data field headers to the XLS exported document. (Inherited from PivotXlsExportOptionsBase)
Public property ExportFilterAreaHeaders Gets or sets whether to include the filter field headers to the XLS exported document. (Inherited from PivotXlsExportOptionsBase)
Public property ExportHyperlinks This property is not supported by the PivotXlsExportOptions class. Use the DevExpress.XtraPrinting.XlsExportOptionsEx.AllowHyperLinks property instad. (Inherited from XlsExportOptionsEx)
Public property ExportMode Specifies whether the document should be exported to a single or different XLS files, page-by-page. (Inherited from XlsExportOptions)
Public property ExportRowAreaHeaders Gets or sets whether to include the row field headers to the XLS exported document. (Inherited from PivotXlsExportOptionsBase)
Public property ExportType Gets or sets export type. (Inherited from XlsExportOptionsEx)
Public property FitToPrintedPageHeight For internal use. (Inherited from XlsExportOptionsEx)
Public property FitToPrintedPageWidth For internal use. (Inherited from XlsExportOptionsEx)
Public property GroupState Gets or sets the expanded state of data groups in the output document. (Inherited from XlsExportOptionsEx)
Public property IgnoreErrors Specifies the document errors to be ignored in a resulting Excel file. (Inherited from XlExportOptionsBase)
Public property LayoutMode Gets or sets whether data is exported in regular mode or as a native Excel table. (Inherited from XlsExportOptionsEx)
Public property PageRange For internal use. (Inherited from XlsExportOptionsEx)
Public property RasterizationResolution For internal use. (Inherited from XlsExportOptionsEx)
Public property RasterizeImages For internal use. (Inherited from XlsExportOptionsEx)
Public property RawDataMode Enables the export mode, which exports only a report's actual data to Excel (excluding all non-relevant elements, such as images, graphics, font and appearance settings). (Inherited from XlExportOptionsBase)
Public property RightToLeftDocument Gets or sets whether the layout of the resulting XLS document should be aligned to support locales using right-to-left fonts. (Inherited from XlExportOptionsBase)
Public property SheetName Gets or sets a name of the sheet in the created XLS file, to which a document is exported. (Inherited from XlExportOptionsBase)
Public property ShowBandHeaders Gets or sets whether band headers are visible in the exported document. This option is in effect when exporting from Banded Grid Views if the DevExpress.XtraPrinting.XlsExportOptionsEx.BandedLayoutMode option is set to Default. (Inherited from XlsExportOptionsEx)
Public property ShowColumnHeaders Gets or sets whether column headers are visible in the exported document. (Inherited from XlsExportOptionsEx)
Public property ShowGridLines Gets or sets a value indicating whether the grid lines should be visible in the resulting XLS file. (Inherited from XlExportOptionsBase)
Public property ShowGroupSummaries Gets or sets whether group summaries are enabled in the exported document. (Inherited from XlsExportOptionsEx)
Public property ShowPageTitle Gets or sets whether a title is displayed for each print preview page of the exported document. (Inherited from XlsExportOptionsEx)
Public property ShowTotalSummaries Gets or sets whether total summaries are enabled in the exported document. (Inherited from XlsExportOptionsEx)
Public property SummaryCountBlankCells Gets or sets whether the Count summary function exported to Excel format takes into account all cells or only non-blank cells. (Inherited from XlsExportOptionsEx)
Public property Suppress256ColumnsWarning Gets or sets a value indicating whether to suppress the exception that raises when trying to export a document to an XLS file with more than 256 columns. (Inherited from XlsExportOptions)
Public property Suppress65536RowsWarning Gets or sets a value indicating whether to suppress the exception that raises when trying to export a document to an XLS file with more than 65,536 rows. (Inherited from XlsExportOptions)
Public property SuppressEmptyStrings Gets or sets whether the source control cells with Empty Strings are exported as Blank cells in Excel format. (Inherited from XlsExportOptionsEx)
Public property TextExportMode Gets or sets a value indicating whether the cells in the resulting XLS document should use the same formatting as the original document. (Inherited from XlExportOptionsBase)
Public property UnboundExpressionExportMode Gets or sets whether column values or column expressions are exported for unbound (calculated) columns. (Inherited from XlsExportOptionsEx)
Public property WorkbookColorPaletteCompliance For internal use. (Inherited from XlsExportOptionsEx)
Top

Expanded Public Methods

Show: Inherited
  Name Description
Public method Assign Copies all settings from the options object passed as a parameter. (Inherited from PivotXlsExportOptionsBase)
Public method Equals Determines whether the specified System.Object is equal to the current System.Object. (Inherited from System.Object)
Public methodStatic member Equals Determines whether the specified System.Object instances are considered equal. (Inherited from System.Object)
Public method GetHashCode Serves as a hash function for a particular type. System.Object.GetHashCode is suitable for use in hashing algorithms and data structures like a hash table. (Inherited from System.Object)
Public method GetType Gets the System.Type of the current instance. (Inherited from System.Object)
Public methodStatic member ReferenceEquals Determines whether the specified System.Object instances are the same instance. (Inherited from System.Object)
Public method ToString Returns a System.String that represents the current System.Object. (Inherited from System.Object)
Top

Expanded Public Events

Show: Inherited
  Name Description
Public event AfterAddRow When exporting to XLS format, this event fires immediately after a row has been added to the output document. (Inherited from XlsExportOptionsEx)
Public event BeforeExportTable Allows you to customize settings of a native Excel table prior to export. This event is in effect when the DevExpress.XtraPrinting.XlsExportOptionsEx.LayoutMode property is set to Table. (Inherited from XlsExportOptionsEx)
Public event CustomizeCell Allows you to customize a PivotGrid's cell in the exported XLS document.
Public event CustomizeDocumentColumn (Inherited from XlsExportOptionsEx)
Public event CustomizeSheetFooter When exporting to XLS format, this event allows you to add a footer to the output document. (Inherited from XlsExportOptionsEx)
Public event CustomizeSheetHeader When exporting to XLS format, this event allows you to add a header to the output document. (Inherited from XlsExportOptionsEx)
Public event CustomizeSheetSettings When exporting to XLS format, this event allows you to customize the output document's settings. (Inherited from XlsExportOptionsEx)
Public event DocumentColumnFiltering Allows you to apply filters to columns in the exported document. (Inherited from XlsExportOptionsEx)
Public event ExportProgress Fires repeatedly while the data is being exported. (Inherited from XlsExportOptionsEx)
Public event SkipFooterRow Allows you to hide certain summary footers (or certain lines of multi-line summary footers) from the export output. (Inherited from XlsExportOptionsEx)
Top

Expanded See Also

How would you rate this topic?​​​​​​​