[Expand]General Information
[Expand]WinForms Controls
[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]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Collapse]Cross-Platform Core Libraries
 [Expand]DevExpress Data Library
 [Expand]DevExpress Pivot Grid Core Library
 [Expand]Miscellaneous
 [Collapse]API Reference
  [Expand]DevExpress.Data
  [Expand]DevExpress.Data.Browsing
  [Expand]DevExpress.Data.Browsing.Design
  [Expand]DevExpress.Data.Camera
  [Expand]DevExpress.Data.Controls
  [Expand]DevExpress.Data.Controls.ExpressionEditor
  [Expand]DevExpress.Data.Entity
  [Expand]DevExpress.Data.Filtering
  [Expand]DevExpress.Data.Filtering.Exceptions
  [Expand]DevExpress.Data.Filtering.Helpers
  [Expand]DevExpress.Data.Linq
  [Expand]DevExpress.Data.ODataLinq
  [Expand]DevExpress.Data.PivotGrid
  [Expand]DevExpress.Data.PLinq
  [Expand]DevExpress.Data.TreeList
  [Expand]DevExpress.Data.Utils
  [Expand]DevExpress.Data.Utils.ServiceModel
  [Expand]DevExpress.Data.WcfLinq
  [Expand]DevExpress.Data.WizardFramework
  [Expand]DevExpress.Data.XtraReports.DataProviders
  [Expand]DevExpress.Data.XtraReports.Labels
  [Expand]DevExpress.Data.XtraReports.ServiceModel
  [Expand]DevExpress.Data.XtraReports.ServiceModel.DataContracts
  [Expand]DevExpress.Data.XtraReports.Wizard
  [Expand]DevExpress.Data.XtraReports.Wizard.Presenters
  [Expand]DevExpress.Data.XtraReports.Wizard.Views
  [Expand]DevExpress.DataAccess
  [Expand]DevExpress.DataAccess.ConnectionParameters
  [Expand]DevExpress.DataAccess.DataFederation
  [Expand]DevExpress.DataAccess.EntityFramework
  [Expand]DevExpress.DataAccess.Excel
  [Expand]DevExpress.DataAccess.ExpressionEditor
  [Expand]DevExpress.DataAccess.Json
  [Expand]DevExpress.DataAccess.Localization
  [Expand]DevExpress.DataAccess.ObjectBinding
  [Expand]DevExpress.DataAccess.Sql
  [Expand]DevExpress.DataAccess.Sql.DataApi
  [Expand]DevExpress.DataAccess.UI
  [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.DataAccess.Web
  [Expand]DevExpress.DataAccess.Wizard
  [Expand]DevExpress.DataAccess.Wizard.Model
  [Expand]DevExpress.DataAccess.Wizard.Presenters
  [Expand]DevExpress.DataAccess.Wizard.Services
  [Expand]DevExpress.DataAccess.Wizard.Views
  [Expand]DevExpress.Diagram.Core
  [Expand]DevExpress.Diagram.Core.Layout
  [Expand]DevExpress.Diagram.Core.Localization
  [Expand]DevExpress.Diagram.Core.Shapes
  [Expand]DevExpress.Diagram.Core.Themes
  [Expand]DevExpress.DocumentServices.ServiceModel
  [Expand]DevExpress.DocumentServices.ServiceModel.Client
  [Expand]DevExpress.DocumentServices.ServiceModel.DataContracts
  [Expand]DevExpress.DocumentView
  [Expand]DevExpress.Entity.Model
  [Expand]DevExpress.Entity.ProjectModel
  [Expand]DevExpress.Export
  [Expand]DevExpress.Export.Xl
  [Expand]DevExpress.Map
  [Expand]DevExpress.Mvvm
  [Expand]DevExpress.Mvvm.DataAnnotations
  [Expand]DevExpress.Mvvm.DataModel
  [Expand]DevExpress.Mvvm.Gantt
  [Expand]DevExpress.Mvvm.ModuleInjection
  [Expand]DevExpress.Mvvm.UI
  [Expand]DevExpress.Mvvm.Utils
  [Expand]DevExpress.Mvvm.ViewModel
  [Expand]DevExpress.Office.Crypto
  [Expand]DevExpress.PivotGrid.Printing
  [Expand]DevExpress.Printing
  [Expand]DevExpress.Printing.Core
  [Expand]DevExpress.Printing.ExportHelpers
  [Expand]DevExpress.ReportServer.Printing
  [Expand]DevExpress.ReportServer.Printing.Services
  [Expand]DevExpress.ReportServer.ServiceModel.Client
  [Expand]DevExpress.ReportServer.ServiceModel.ConnectionProviders
  [Expand]DevExpress.ReportServer.ServiceModel.DataContracts
  [Expand]DevExpress.Schedule
  [Expand]DevExpress.Security.Resources
  [Expand]DevExpress.Services
  [Expand]DevExpress.Sparkline
  [Expand]DevExpress.TreeMap
  [Expand]DevExpress.Utils
  [Expand]DevExpress.Utils.Commands
  [Expand]DevExpress.Utils.Controls
  [Expand]DevExpress.Utils.Filtering.Internal
  [Expand]DevExpress.Utils.IoC
  [Expand]DevExpress.Utils.Localization
  [Expand]DevExpress.Utils.Serializing.Helpers
  [Expand]DevExpress.Utils.Svg
  [Expand]DevExpress.WebUtils
  [Expand]DevExpress.Xpf.Core
  [Expand]DevExpress.Xpf.Printing
  [Expand]DevExpress.Xpo
  [Expand]DevExpress.Xpo.DB
  [Expand]DevExpress.Xpo.DB.Exceptions
  [Expand]DevExpress.Xpo.DB.Helpers
  [Expand]DevExpress.Xpo.Helpers
  [Expand]DevExpress.XtraCharts
  [Expand]DevExpress.XtraCharts.Localization
  [Expand]DevExpress.XtraCharts.Native
  [Expand]DevExpress.XtraCharts.Printing
  [Expand]DevExpress.XtraEditors
  [Expand]DevExpress.XtraEditors.DXErrorProvider
  [Expand]DevExpress.XtraExport.Csv
  [Expand]DevExpress.XtraGauges.Base
  [Expand]DevExpress.XtraGauges.Core
  [Expand]DevExpress.XtraGauges.Core.Base
  [Expand]DevExpress.XtraGauges.Core.Drawing
  [Expand]DevExpress.XtraGauges.Core.Localization
  [Expand]DevExpress.XtraGauges.Core.Model
  [Expand]DevExpress.XtraGauges.Core.Primitive
  [Expand]DevExpress.XtraGrid
  [Collapse]DevExpress.XtraPivotGrid
    AdomdVersion Enumeration
    AllowHideFieldsType Enumeration
    AsyncCompletedHandler Delegate
   [Expand]AsyncOperationResult Class
   [Expand]BaseFilter Class
    CopyCollapsedValuesMode Enumeration
    CopyMultiSelectionMode Enumeration
   [Expand]CrossAreaKey Class
   [Expand]CustomCustomizationFormSortEventArgsBase<T> Class
   [Expand]CustomFieldDataEventArgsBase<T> Class
   [Expand]CustomServerModeSortEventArgsBase<T> Class
    DataFieldUnboundExpressionMode Enumeration
    ExportCellType Enumeration
   [Expand]FieldValueCellBase<T> Class
   [Expand]IOLAPMember Interface
   [Expand]IPivotCustomSummaryValue Interface
   [Expand]IThreadSafeAccessible Interface
   [Expand]IThreadSafeField Interface
   [Expand]IThreadSafeFieldCollection Interface
   [Expand]IThreadSafeGroup Interface
   [Expand]IThreadSafeGroupCollection Interface
    OLAPDataProvider Enumeration
    PivotArea Enumeration
   [Expand]PivotCellEventArgsBase<TField, TData, TCustomTotal> Class
    PivotChartDataProvideMode Enumeration
    PivotChartDataProvidePriority Enumeration
   [Expand]PivotChartDataSourceRowBase Class
    PivotChartFieldValuesProvideMode Enumeration
    PivotChartItemDataMember Enumeration
    PivotChartItemType Enumeration
   [Expand]PivotCustomFieldValueCellsEventArgsBase<T1, T2> Class
   [Expand]PivotCustomGroupIntervalEventArgsBase<T> Class
    PivotDataArea Enumeration
    PivotDataProcessingEngine Enumeration
   [Expand]PivotDataSource Class
    PivotDefaultMemberFields Enumeration
   [Expand]PivotDrillDownDataRow Class
   [Expand]PivotDrillDownDataSource Class
    PivotExportArea Enumeration
   [Expand]PivotFieldDisplayTextEventArgsBase<T> Class
   [Expand]PivotFieldEventArgsBase<T> Class
    PivotFieldPropertyName Enumeration
   [Expand]PivotFieldValueEventArgsBase<T> Class
   [Expand]PivotFilterBase Class
    PivotFilterType Enumeration
   [Expand]PivotGridAdomdDataSource Class
    PivotGridAllowedAreas Enumeration
    PivotGridBestFitMode Enumeration
   [Expand]PivotGridCustomFieldSortEventArgsBase<T> Class
   [Expand]PivotGridCustomTotalBase Class
   [Expand]PivotGridCustomTotalCollectionBase Class
   [Expand]PivotGridFieldBase Class
   [Expand]PivotGridFieldCollectionBase Class
   [Expand]PivotGridFieldFilterValues Class
   [Expand]PivotGridFieldOptions Class
   [Expand]PivotGridFieldSortBySummaryInfo Class
   [Expand]PivotGridFieldSortCondition Class
   [Expand]PivotGridFieldSortConditionCollection Class
   [Expand]PivotGridGroup Class
   [Expand]PivotGridGroupCollection Class
   [Expand]PivotGridOptionsBase Class
   [Expand]PivotGridOptionsBehaviorBase Class
   [Expand]PivotGridOptionsChartDataSource Class
   [Expand]PivotGridOptionsCustomization Class
   [Expand]PivotGridOptionsData Class
   [Expand]PivotGridOptionsDataField Class
   [Expand]PivotGridOptionsFilterBase Class
   [Expand]PivotGridOptionsLayout Class
   [Expand]PivotGridOptionsOLAP Class
   [Expand]PivotGridOptionsPrint Class
   [Expand]PivotGridOptionsSelection Class
   [Expand]PivotGridOptionsViewBase Class
   [Expand]PivotGridPageSettings Class
    PivotGridResetOptions Enumeration
    PivotGridValueType Enumeration
   [Expand]PivotGridXmlaDataSource Class
    PivotGroupFilterMode Enumeration
   [Expand]PivotGroupFilterValue Class
   [Expand]PivotGroupFilterValues Class
   [Expand]PivotGroupFilterValuesCollection Class
    PivotGroupInterval Enumeration
    PivotKPIGraphic Enumeration
    PivotKPIType Enumeration
    PivotOLAPFilterUsingWhereClause Enumeration
   [Expand]PivotOLAPKPIMeasures Class
   [Expand]PivotOLAPKPIValue Class
   [Expand]PivotOptionsChangedEventArgs Class
    PivotOptionsChangedEventHandler Delegate
   [Expand]PivotOptionsFilterEventArgs Class
    PivotOptionsFilterEventHandler Delegate
    PivotRowTotalsLocation Enumeration
    PivotSortBySummaryOrder Enumeration
    PivotSortLocation Enumeration
    PivotSortMode Enumeration
    PivotSortOrder Enumeration
   [Expand]PivotSummaryDataRow Class
   [Expand]PivotSummaryDataSource Class
   [Expand]PivotSummaryFilter Class
    PivotSummaryFilterMode Enumeration
    PivotSummaryFilterValidity Enumeration
   [Expand]PivotSummaryInterval Class
    PivotTopValueType Enumeration
    PivotTotalsLocation Enumeration
    PivotTotalsVisibility Enumeration
   [Expand]PivotXlsExportOptionsBase Class
   [Collapse]PivotXlsxExportOptionsBase Class
     PivotXlsxExportOptionsBase Members
    [Collapse]PivotXlsxExportOptionsBase Properties
      ExportColumnAreaHeaders Property
      ExportDataAreaHeaders Property
      ExportFilterAreaHeaders Property
      ExportRowAreaHeaders Property
    [Expand]PivotXlsxExportOptionsBase Methods
   [Expand]PrefilterBase Class
    TopValueMode Enumeration
    UnboundExpressionMode Enumeration
  [Expand]DevExpress.XtraPivotGrid.Customization
  [Expand]DevExpress.XtraPivotGrid.Data
  [Expand]DevExpress.XtraPivotGrid.Localization
  [Expand]DevExpress.XtraPivotGrid.Selection
  [Expand]DevExpress.XtraPrinting
  [Expand]DevExpress.XtraPrinting.BarCode
  [Expand]DevExpress.XtraPrinting.Caching
  [Expand]DevExpress.XtraPrinting.DataNodes
  [Expand]DevExpress.XtraPrinting.Drawing
  [Expand]DevExpress.XtraPrinting.Export
  [Expand]DevExpress.XtraPrinting.Export.Web
  [Expand]DevExpress.XtraPrinting.Localization
  [Expand]DevExpress.XtraPrinting.Native
  [Expand]DevExpress.XtraPrinting.Shape
  [Expand]DevExpress.XtraPrinting.Shape.Native
  [Expand]DevExpress.XtraPrinting.WebClientUIControl.DataContracts
  [Expand]DevExpress.XtraPrinting.XamlExport
  [Expand]DevExpress.XtraPrintingLinks
  [Expand]DevExpress.XtraReports
  [Expand]DevExpress.XtraReports.Design
  [Expand]DevExpress.XtraReports.Parameters
  [Expand]DevExpress.XtraReports.ReportGeneration
  [Expand]DevExpress.XtraReports.UI
  [Expand]DevExpress.XtraScheduler
  [Expand]DevExpress.XtraScheduler.Compatibility
  [Expand]DevExpress.XtraScheduler.Drawing
  [Expand]DevExpress.XtraScheduler.Exchange
  [Expand]DevExpress.XtraScheduler.iCalendar
  [Expand]DevExpress.XtraScheduler.iCalendar.Components
  [Expand]DevExpress.XtraScheduler.Localization
  [Expand]DevExpress.XtraScheduler.Native
  [Expand]DevExpress.XtraScheduler.Outlook
  [Expand]DevExpress.XtraScheduler.Outlook.Interop
  [Expand]DevExpress.XtraScheduler.Reporting
  [Expand]DevExpress.XtraScheduler.Services
  [Expand]DevExpress.XtraScheduler.Services.Implementation
  [Expand]DevExpress.XtraScheduler.Tools
  [Expand]DevExpress.XtraScheduler.UI
  [Expand]DevExpress.XtraScheduler.Xml
  [Expand]DevExpress.XtraSpellChecker
  [Expand]DevExpress.XtraSpellChecker.Rules
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

PivotXlsxExportOptionsBase Properties

Represents the base class for objects which define the PivotGrid's export options specific to XLSX format.

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.Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property AllowCellMerge Gets or sets whether cell merging is enabled in the exported document.Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property AllowCombinedBandAndColumnHeaderCellMerge Gets or sets whether the headers of the same name are exported as merged cells. Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property AllowConditionalFormatting Gets or sets whether conditional formatting rules applied to columns are preserved in the exported document.Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property AllowFixedColumnHeaderPanel Gets or sets whether the column header panel is anchored to the top of the export document and not scrolled vertically. Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property AllowFixedColumns Gets or sets whether left fixed columns enabled in a grid control are fixed in the exported document.Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property AllowGrouping Gets or sets whether data groups are exported from the source control to the output document.Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property AllowHyperLinks Gets or sets whether hyperlinks are exported.Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property AllowLookupValues Gets or sets whether combo-box and lookup columns' lookup values are exported.Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property AllowSortingAndFiltering Gets or sets whether columns' sorting and filtering functionality is enabled in the exported document.Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property AllowSparklines Gets or sets whether sparklines are exported.Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property ApplyFormattingToEntireColumn Gets or sets whether cell formatting (cell appearance and borders) is applied to the entire sheet columns (faster) or individual sheet cells in the range of exported rows (slower). Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property AutoCalcConditionalFormattingIconSetMinValue Gets or sets whether to set the minimum value for the Icon Set conditional formatting rule explicitly.Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property BandedLayoutMode Gets or sets how bands and columns are arranged in the output worksheet (when exporting from Banded Views).Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property CalcTotalSummaryOnCompositeRange Gets or sets whether a formula exported as total summary excludes cells with group summary values even if group summaries are calculated at runtime as custom summaries.Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property DocumentCulture Gets or sets the export document's culture which defines numeric and date-time data formatting settings. Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property DocumentOptions Provides access to options to be embedded as the resulting XLS or XLSX file's Document Properties. (Inherited from XlExportOptionsBase)
Public property EncryptionOptions Provides access to the XLS and XLSX file encryption options. (Inherited from XlExportOptionsBase)
Public property ExportColumnAreaHeaders Gets or sets whether to include the column field headers in the XLSX exported document.
Public property ExportDataAreaHeaders Gets or sets whether to include the data field headers in the XLSX exported document.
Public property ExportFilterAreaHeaders Gets or sets whether to include the filter field headers in the XLSX exported document.
Public property ExportHyperlinks This property is not supported by the XlsxExportOptionsEx class. Use the XlsxExportOptionsEx.AllowHyperLinks property instead.Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property ExportMode Specifies whether the source is exported as a single XLSX file or multiple files, and whether each page is exported as a separate worksheet. (Inherited from XlsxExportOptions)
Public property ExportRowAreaHeaders Gets or sets whether to include the row field headers in the XLSX exported document.
Public property ExportType Gets or sets the export type - WYSIWYG or Data Aware. (Inherited from XlsxExportOptionsEx)
Public property FitToPrintedPageHeight For internal use. (Inherited from XlsxExportOptionsEx)
Public property FitToPrintedPageWidth For internal use. (Inherited from XlsxExportOptionsEx)
Public property GroupState Gets or sets data groups' expanded state in the exported document. Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
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.Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property PageRange For internal use. (Inherited from XlsxExportOptionsEx)
Public property RasterizationResolution For internal use. (Inherited from XlsxExportOptionsEx)
Public property RasterizeImages For internal use. (Inherited from XlsxExportOptionsEx)
Public property RawDataMode Enables the mode that produces simple tabular data without graphic elements, style 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 XlsxExportOptionsEx.BandedLayoutMode option is set to Default. Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property ShowColumnHeaders Gets or sets whether column headers are visible in the exported document.Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
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.Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property ShowPageTitle Gets or sets whether a title is displayed for each print preview page of the exported document. Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property ShowTotalSummaries Gets or sets whether total summaries are enabled in the exported document.Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property SummaryCountBlankCells Gets or sets whether the Count summary function takes all cells into account or only non-blank cells when exporting to Excel format.Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property SuppressEmptyStrings Gets or sets whether the source control cells with Empty Strings are exported as Blank cells in Excel format.Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property SuppressHyperlinkMaxCountWarning (Inherited from XlsxExportOptionsEx)
Public property SuppressMaxColumnsWarning Gets or sets whether to suppress the exception that is raised if you export more than 16,384 columns to an XLSX file.Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Public property SuppressMaxRowsWarning Gets or sets whether to suppress the exception that is raised on attempting to export more than 1,048,576 rows to an XLSX file. Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
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.Only available in data-aware export mode. (Inherited from XlsxExportOptionsEx)
Top

Expanded See Also

Is this topic helpful?​​​​​​​