[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]ASP.NET WebForms Controls
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Collapse]API Reference
  [Expand]DevExpress.Data.Linq
  [Expand]DevExpress.Web
  [Expand]DevExpress.Web.ASPxGauges
  [Expand]DevExpress.Web.ASPxGauges.Base
  [Expand]DevExpress.Web.ASPxGauges.Scripts
  [Expand]DevExpress.Web.ASPxHtmlEditor
  [Expand]DevExpress.Web.ASPxHtmlEditor.Localization
  [Expand]DevExpress.Web.ASPxHtmlEditor.Scripts
  [Collapse]DevExpress.Web.ASPxPivotGrid
   [Expand]ASPxPivotCustomizationControl Class
   [Expand]ASPxPivotGrid Class
   [Expand]ASPxPivotGridExporter Class
   [Expand]ASPxPivotGridPager Class
   [Expand]ASPxPivotGridPopupMenu Class
   [Expand]CustomCustomizationFormSortEventArgs Class
   [Expand]CustomFieldDataEventArgs Class
    CustomFieldDataEventHandler Delegate
   [Expand]CustomizePivotCellEventArgs Class
    CustomizePivotCellEventHandler Delegate
   [Expand]CustomServerModeSortEventArgs Class
   [Expand]FieldValueCell Class
    MenuItemEnum Enumeration
    PagerAlign Enumeration
   [Expand]PivotAddPopupMenuItemEventArgs Class
    PivotAddPopupMenuItemEventHandler Delegate
   [Expand]PivotAreaChangingEventArgs Class
    PivotAreaChangingEventHandler Delegate
   [Expand]PivotAreaStyle Class
   [Expand]PivotCellBaseEventArgs Class
   [Expand]PivotCellDisplayTextEventArgs Class
    PivotCellDisplayTextEventHandler Delegate
   [Expand]PivotCellStyle Class
   [Expand]PivotCellValueEventArgs Class
   [Expand]PivotChartDataSourceRow Class
    PivotCollapsedStateStoreMode Enumeration
    PivotCustomCallbackEventHandler Delegate
   [Expand]PivotCustomCellStyleEventArgs Class
    PivotCustomCellStyleEventHandler Delegate
   [Expand]PivotCustomChartDataSourceDataEventArgs Class
    PivotCustomChartDataSourceDataEventHandler Delegate
   [Expand]PivotCustomChartDataSourceRowsEventArgs Class
    PivotCustomChartDataSourceRowsEventHandler Delegate
   [Expand]PivotCustomFieldValueCellsEventArgs Class
   [Expand]PivotCustomFilterPopupItemsEventArgs Class
   [Expand]PivotCustomGroupIntervalEventArgs Class
   [Expand]PivotCustomizationFormImages Class
   [Expand]PivotDataAreaPopupCreatedEventArgs Class
    PivotDataHeadersDisplayMode Enumeration
   [Expand]PivotFieldDisplayTextEventArgs Class
    PivotFieldDisplayTextEventHandler Delegate
   [Expand]PivotFieldEventArgs Class
    PivotFieldEventHandler Delegate
   [Expand]PivotFieldFilterChangingEventArgs Class
    PivotFieldFilterChangingEventHandler Delegate
   [Expand]PivotFieldPropertyChangedEventArgs Class
    PivotFieldPropertyChangedEventHandler Delegate
   [Expand]PivotFieldStateChangedCancelEventArgs Class
    PivotFieldStateChangedCancelEventHandler Delegate
   [Expand]PivotFieldStateChangedEventArgs Class
    PivotFieldStateChangedEventHandler Delegate
   [Expand]PivotFieldValueEventArgs Class
    PivotFieldValueEventHandler Delegate
   [Expand]PivotFieldValueStyle Class
   [Expand]PivotFilterButtonPanelStyle Class
   [Expand]PivotFilterButtonStyle Class
   [Expand]PivotFilterItemStyle Class
   [Expand]PivotFilterStyle Class
   [Expand]PivotGridCallbackStateEventArgs Class
    PivotGridCallbackStateEventHandler Delegate
   [Expand]PivotGridCellTemplateContainer Class
   [Expand]PivotGridCellTemplateItem Class
   [Expand]PivotGridClientSideEvents Class
   [Expand]PivotGridCustomCallbackEventArgs Class
   [Expand]PivotGridCustomFieldSortEventArgs Class
    PivotGridCustomFieldSortEventHandler Delegate
    PivotGridCustomGroupIntervalEventHandler Delegate
   [Expand]PivotGridCustomSummaryEventArgs Class
    PivotGridCustomSummaryEventHandler Delegate
   [Expand]PivotGridCustomTotal Class
   [Expand]PivotGridCustomTotalCollection Class
   [Expand]PivotGridEmptyAreaTemplateContainer Class
   [Expand]PivotGridField Class
   [Expand]PivotGridFieldCollection Class
   [Expand]PivotGridFieldValueTemplateContainer Class
   [Expand]PivotGridFieldValueTemplateItem Class
    PivotGridHeaderFilterListBoxSearchUIVisibility Enumeration
   [Expand]PivotGridHeaderTemplateContainer Class
   [Expand]PivotGridImageProperties Class
   [Expand]PivotGridImages Class
   [Expand]PivotGridPagerStyles Class
    PivotGridPopupMenuType Enumeration
    PivotGridResetOptions Enumeration
   [Expand]PivotGridStyles Class
   [Expand]PivotGridWebFieldOptions Class
   [Expand]PivotGridWebFieldOptionsFilter Class
   [Expand]PivotGridWebGroup Class
   [Expand]PivotGridWebGroupCollection Class
   [Expand]PivotGridWebOptionsBehavior Class
   [Expand]PivotGridWebOptionsChartDataSource Class
   [Expand]PivotGridWebOptionsCustomization Class
   [Expand]PivotGridWebOptionsData Class
   [Expand]PivotGridWebOptionsDataField Class
   [Expand]PivotGridWebOptionsFilter Class
   [Expand]PivotGridWebOptionsLayout Class
   [Expand]PivotGridWebOptionsLoadingPanel Class
   [Expand]PivotGridWebOptionsPager Class
   [Expand]PivotGridWebOptionsView Class
   [Expand]PivotGroupEventArgs Class
    PivotGroupEventHandler Delegate
   [Expand]PivotHeaderStyle Class
   [Expand]PivotHtmlCellPreparedEventArgs Class
    PivotHtmlCellPreparedEventHandler Delegate
   [Expand]PivotHtmlFieldValuePreparedEventArgs Class
    PivotHtmlFieldValuePreparedEventHandler Delegate
   [Expand]PivotOlapExceptionEventArgs Class
    PivotOlapExceptionEventHandler Delegate
   [Expand]PivotOlapQueryDataEventArgs Class
   [Expand]PivotPopupMenuCreatedEventArgs Class
   [Expand]PivotQueryExceptionEventArgs Class
    PivotQueryExceptionEventHandler Delegate
    PivotScrollingMode Enumeration
   [Collapse]PivotXlsExportOptions Class
     PivotXlsExportOptions Members
    [Expand]PivotXlsExportOptions Constructor
    [Expand]PivotXlsExportOptions Events
   [Expand]PivotXlsxExportOptions Class
   [Expand]WebCustomExportCellEventArgs Class
   [Expand]WebCustomExportFieldValueEventArgs Class
   [Expand]WebCustomExportHeaderEventArgs Class
   [Expand]WebPivotGridOptionsPrint Class
  [Expand]DevExpress.Web.ASPxPivotGrid.Data
  [Expand]DevExpress.Web.ASPxPivotGrid.HtmlControls
  [Expand]DevExpress.Web.ASPxPivotGrid.Scripts
  [Expand]DevExpress.Web.ASPxRichEdit
  [Expand]DevExpress.Web.ASPxRichEdit.Localization
  [Expand]DevExpress.Web.ASPxRichEdit.Scripts
  [Expand]DevExpress.Web.ASPxScheduler
  [Expand]DevExpress.Web.ASPxScheduler.Commands
  [Expand]DevExpress.Web.ASPxScheduler.Commands.Dialogs
  [Expand]DevExpress.Web.ASPxScheduler.Controls
  [Expand]DevExpress.Web.ASPxScheduler.Dialogs
  [Expand]DevExpress.Web.ASPxScheduler.Drawing
  [Expand]DevExpress.Web.ASPxScheduler.Localization
  [Expand]DevExpress.Web.ASPxScheduler.Reporting
  [Expand]DevExpress.Web.ASPxScheduler.Scripts
  [Expand]DevExpress.Web.ASPxSpellChecker
  [Expand]DevExpress.Web.ASPxSpellChecker.Localization
  [Expand]DevExpress.Web.ASPxSpellChecker.Scripts
  [Expand]DevExpress.Web.ASPxSpreadsheet
  [Expand]DevExpress.Web.ASPxSpreadsheet.Localization
  [Expand]DevExpress.Web.ASPxSpreadsheet.Scripts
  [Expand]DevExpress.Web.ASPxTreeList
  [Expand]DevExpress.Web.ASPxTreeList.Internal
  [Expand]DevExpress.Web.ASPxTreeList.Localization
  [Expand]DevExpress.Web.ASPxTreeList.Scripts
  [Expand]DevExpress.Web.Captcha
  [Expand]DevExpress.Web.Data
  [Expand]DevExpress.Web.Internal
  [Expand]DevExpress.Web.Localization
  [Expand]DevExpress.Web.Mvc
  [Expand]DevExpress.Web.Mvc.BinderSettings
  [Expand]DevExpress.Web.Mvc.Controllers
  [Expand]DevExpress.Web.MVC.Scripts
  [Expand]DevExpress.Web.Mvc.UI
  [Expand]DevExpress.Web.Office
  [Expand]DevExpress.Web.Office.Internal
  [Expand]DevExpress.Web.Rendering
  [Expand]DevExpress.Web.Scripts
  [Expand]DevExpress.XtraCharts.Web
  [Expand]DevExpress.XtraCharts.Web.Designer
  [Expand]DevExpress.XtraCharts.Web.Scripts
[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
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

PivotXlsExportOptions Members

Contains options that define how a Pivot Grid control 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.
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. Only available in data-aware export mode. (Inherited from XlsExportOptionsEx)
Public property AllowCellMerge Gets or sets whether cell merging is enabled in the exported document. Only available in data-aware export mode. (Inherited from XlsExportOptionsEx)
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 XlsExportOptionsEx)
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 XlsExportOptionsEx)
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 XlsExportOptionsEx)
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 XlsExportOptionsEx)
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 XlsExportOptionsEx)
Public property AllowHyperLinks Gets or sets whether hyperlinks are exported. Only available in data-aware export mode. (Inherited from XlsExportOptionsEx)
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 XlsExportOptionsEx)
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 XlsExportOptionsEx)
Public property AllowSparklines Gets or sets whether sparklines are exported. Only available in data-aware export mode. (Inherited from XlsExportOptionsEx)
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 XlsExportOptionsEx)
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 XlsExportOptionsEx)
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 XlsExportOptionsEx)
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 XlsExportOptionsEx)
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 XlsExportOptionsEx)
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 XLS exported document. (Inherited from PivotXlsExportOptionsBase)
Public property ExportDataAreaHeaders Gets or sets whether to include the data field headers in the XLS exported document. (Inherited from PivotXlsExportOptionsBase)
Public property ExportFilterAreaHeaders Gets or sets whether to include the filter field headers in 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 instead. Only available in data-aware export mode. (Inherited from XlsExportOptionsEx)
Public property ExportMode Specifies whether the document should be exported to a single or different XLS files, each page in a separate file. (Inherited from XlsExportOptions)
Public property ExportRowAreaHeaders Gets or sets whether to include the row field headers in the XLS exported document. (Inherited from PivotXlsExportOptionsBase)
Public property ExportType Gets or sets the export type - WYSIWYG or Data Aware. (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 data groups' expanded state in the exported document. Only available in data-aware export mode. (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. Only available in data-aware export mode. (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 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 DevExpress.XtraPrinting.XlsExportOptionsEx.BandedLayoutMode option is set to Default. Only available in data-aware export mode. (Inherited from XlsExportOptionsEx)
Public property ShowColumnHeaders Gets or sets whether column headers are visible in the exported document. Only available in data-aware export mode. (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. Only available in data-aware export mode. (Inherited from XlsExportOptionsEx)
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 XlsExportOptionsEx)
Public property ShowTotalSummaries Gets or sets whether total summaries are enabled in the exported document. Only available in data-aware export mode. (Inherited from XlsExportOptionsEx)
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 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. Only available in data-aware export mode. (Inherited from XlsExportOptionsEx)
Public property SuppressHyperlinkMaxCountWarning (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. Only available in data-aware export mode. (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 Fires immediately after a row is added to the output document. Only available in data-aware export mode. (Inherited from XlsExportOptionsEx)
Public event BeforeExportTable Allows you to customize a native Excel table's settings before export. This event is in effect when the DevExpress.XtraPrinting.XlsExportOptionsEx.LayoutMode property is set to Table. Only available in data-aware export mode. (Inherited from XlsExportOptionsEx)
Public event CustomizeCell Allows you to specify cell formatting when exporting a Pivot Grid control to XLSX format in data-aware mode.
Public event CustomizeDocumentColumn Allows you to customize an individual column in the exported document - change its width, formatting, collapse the group containing the column or hide the column. (Inherited from XlsExportOptionsEx)
Public event CustomizeSheetFooter Allows you to add a footer to the output document. Only available in data-aware export mode. (Inherited from XlsExportOptionsEx)
Public event CustomizeSheetHeader Allows you to add a header to the output document. Only available in data-aware export mode. (Inherited from XlsExportOptionsEx)
Public event CustomizeSheetSettings Allows you to customize the output document's settings. Only available in data-aware export mode. (Inherited from XlsExportOptionsEx)
Public event DocumentColumnFiltering Allows you to apply filters to the exported document's columns. Only available in data-aware export mode. (Inherited from XlsExportOptionsEx)
Public event ExportProgress Fires repeatedly while the data is being exported. Only available in data-aware export mode. (Inherited from XlsExportOptionsEx)
Public event SkipFooterRow Allows you to hide certain summary footers (or certain multi-line summary footers' lines) from the exported document. Only available in data-aware export mode. (Inherited from XlsExportOptionsEx)
Top

Expanded See Also

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