Skip to main content
BuyLog In
WPF Controls
Search in…
Docs > API Reference > DevExpress.Xpf.PivotGrid > PivotGridXlsExportOptions > Members
All docs
V23.2
WPF Controls
API Reference
DevExpress.Charts.Designer
DevExpress.Data
DevExpress.Mvvm.Gantt
DevExpress.Mvvm.UI
DevExpress.Mvvm.UI.Interactivity
DevExpress.Mvvm.UI.ModuleInjection
DevExpress.Xpf.Accordion
DevExpress.Xpf.Bars
DevExpress.Xpf.Carousel
DevExpress.Xpf.Charts
DevExpress.Xpf.Charts.Heatmap
DevExpress.Xpf.Charts.Localization
DevExpress.Xpf.Charts.RangeControlClient
DevExpress.Xpf.Charts.Sankey
DevExpress.Xpf.ChunkList
DevExpress.Xpf.Controls
DevExpress.Xpf.Core
DevExpress.Xpf.Core.ConditionalFormatting
DevExpress.Xpf.Core.DataSources
DevExpress.Xpf.Core.FilteringUI
DevExpress.Xpf.Core.Native
DevExpress.Xpf.Core.Serialization
DevExpress.Xpf.Core.ServerMode
DevExpress.Xpf.Data
DevExpress.Xpf.DataAccess
DevExpress.Xpf.DataAccess.DataSourceWizard
DevExpress.Xpf.Diagram
DevExpress.Xpf.Dialogs
DevExpress.Xpf.Docking
DevExpress.Xpf.Docking.Base
DevExpress.Xpf.DocumentViewer
DevExpress.Xpf.DXBinding
DevExpress.Xpf.Editors
DevExpress.Xpf.Editors.DataPager
DevExpress.Xpf.Editors.DateNavigator
DevExpress.Xpf.Editors.ExpressionEditor
DevExpress.Xpf.Editors.ExpressionEditor.Native
DevExpress.Xpf.Editors.Filtering
DevExpress.Xpf.Editors.Flyout
DevExpress.Xpf.Editors.Flyout.Native
DevExpress.Xpf.Editors.Helpers
DevExpress.Xpf.Editors.Native
DevExpress.Xpf.Editors.Popups
DevExpress.Xpf.Editors.RangeControl
DevExpress.Xpf.Editors.Settings
DevExpress.Xpf.Editors.Validation
DevExpress.Xpf.ExpressionEditor
DevExpress.Xpf.Gantt
DevExpress.Xpf.Gauges
DevExpress.Xpf.Gauges.Localization
DevExpress.Xpf.Grid
DevExpress.Xpf.Grid.ConditionalFormatting
DevExpress.Xpf.Grid.LookUp
DevExpress.Xpf.Grid.Printing
DevExpress.Xpf.Grid.TreeList
DevExpress.Xpf.Grid.TreeView
DevExpress.Xpf.Layout.Core
DevExpress.Xpf.LayoutControl
DevExpress.Xpf.Map
DevExpress.Xpf.NavBar
DevExpress.Xpf.Navigation
DevExpress.Xpf.PdfViewer
DevExpress.Xpf.PivotGrid
AllowHideFieldsType
AsyncCompletedHandler
AsyncOperationResult
CalculationBinding
CalculationDirection
CalculationPartitioningCriteria
CellElement
CellElementData
CellInfo
ColorScaleFormatCondition
CopyCollapsedValuesMode
CopyMultiSelectionMode
CustomizePivotCellEventArgs
CustomServerModeSortEventArgs
DataAreaElement
DataAreaElementData
DataBarFormatCondition
DataBinding
DataFieldArea
DataHeadersDisplayMode
DataProcessingEngine
DataSourceColumnBinding
DateTimeGroupIntervals
DefaultMenuItemNames
DifferenceBinding
DifferenceTarget
DifferenceType
DirectedCalculationBinding
EventArgsToCellInfoConverter
EventArgsToFieldValueInfoConverter
ExpressionConditionBase
ExpressionDataBinding
FieldAllowedAreas
FieldArea
FieldBestFitArea
FieldColumnTotalsLocation
FieldFilterType
FieldFilterValues
FieldGroupInterval
FieldListAllowedLayouts
FieldListArea
FieldListControlBase
FieldListLayout
FieldListOrientation
FieldListStyle
FieldOLAPFilterUsingWhereClause
FieldPropertyName
FieldRowTotalsLocation
FieldSortBySummaryOrder
FieldSortLocation
FieldSortMode
FieldSortOrder
FieldSummaryDisplayType
FieldSummaryType
FieldTopValueMode
FieldTopValueType
FieldTotalsVisibility
FieldUnboundColumnType
FieldUnboundExpressionMode
FieldValueCell
FieldValueElement
FieldValueElementData
FieldValueInfo
FieldValueType
FilterPopupMode
FormatCondition
FormatConditionBase
FormatConditionCollection
FormatConditionCommandParameters
GroupChangedEventArgs
GroupChangedEventHandler
GroupChangeType
GroupFilterMode
GroupFilterValue
GroupFilterValues
GroupFilterValuesCollection
IconSetFormatCondition
IndicatorFormatConditionBase
IThreadSafeField
LightweightCellElement
LightweightFieldValueElement
MovingCalculationBinding
OlapDataProvider
OlapExpressionBinding
PercentOfTotalBinding
PivotBrushChangedEventArgs
PivotBrushChangedEventHandler
PivotBrushType
PivotCellBaseEventArgs
PivotCellDisplayTextEventArgs
PivotCellDisplayTextEventHandler
PivotCellEventArgs
PivotCellEventHandler
PivotCellValueEventArgs
PivotCellValueEventHandler
PivotChartDataProvideMode
PivotChartDataProvidePriority
PivotChartDataSourceRow
PivotChartExportFieldValueMode
PivotChartFieldValuesProvideMode
PivotChartItemDataMember
PivotChartItemType
PivotCustomCellAppearanceEventArgs
PivotCustomCellAppearanceEventHandler
PivotCustomChartDataSourceDataEventArgs
PivotCustomChartDataSourceDataEventHandler
PivotCustomChartDataSourceRowsEventArgs
PivotCustomChartDataSourceRowsEventHandler
PivotCustomFieldDataEventArgs
PivotCustomFieldDataEventHandler
PivotCustomFieldListSortEventArgs
PivotCustomFieldSortEventArgs
PivotCustomFieldSortEventHandler
PivotCustomFieldValueCellsEventArgs
PivotCustomFieldValueCellsEventHandler
PivotCustomFilterPopupItemsEventArgs
PivotCustomFilterPopupItemsEventHandler
PivotCustomGroupIntervalEventArgs
PivotCustomGroupIntervalEventHandler
PivotCustomSummaryEventArgs
PivotCustomSummaryEventHandler
PivotCustomValueAppearanceEventArgs
PivotCustomValueAppearanceEventHandler
PivotDefaultMemberFields
PivotDrillDownDataRow
PivotDrillDownDataSource
PivotExcelFieldListControl
PivotExpressionEditorEventArgs
PivotExpressionEditorEventHandler
PivotFieldAreaChangingEventArgs
PivotFieldAreaChangingEventHandler
PivotFieldDisplayTextEventArgs
PivotFieldDisplayTextEventHandler
PivotFieldEventArgs
PivotFieldEventHandler
PivotFieldFilterChangingEventArgs
PivotFieldFilterChangingEventHandler
PivotFieldListControl
PivotFieldPropertyChangedEventArgs
PivotFieldPropertyChangedEventHandler
PivotFieldValueCancelEventArgs
PivotFieldValueCancelEventHandler
PivotFieldValueEventArgs
PivotFieldValueEventHandler
PivotGridCellMenuInfo
PivotGridCommands
PivotGridControl
PivotGridCsvExportOptions
PivotGridCustomTotal
PivotGridCustomTotalCollection
PivotGridField
PivotGridFieldCollection
PivotGridFieldValueMenuInfo
PivotGridFilterPopupMenuInfo
PivotGridGroup
PivotGridGroupCollection
PivotGridHeaderMenuInfo
PivotGridHeadersAreaMenuInfo
PivotGridMenuInfo
PivotGridMenuType
PivotGridPopupMenu
PivotGridXlsExportOptions
Members
Constructors
Properties
Methods
Events
PivotGridXlsxExportOptions
PivotGroupEventArgs
PivotGroupEventHandler
PivotKpiGraphic
PivotKpiType
PivotLayoutAllowEventArgs
PivotLayoutAllowEventHandler
PivotLayoutUpgradeEventArgs
PivotLayoutUpgradeEventHandler
PivotOlapExceptionEventArgs
PivotOlapExceptionEventHandler
PivotOlapKpiMeasures
PivotOlapKpiValue
PivotOlapMember
PivotPropertyChangedEventArgs
PivotPropertyChangedEventHandler
PivotQueryExceptionEventArgs
PivotQueryExceptionEventHandler
PivotSerializationOptions
PivotSummaryDataRow
PivotSummaryDataSource
PivotUnboundExpressionEditorEventArgs
PivotUnboundExpressionEditorEventHandler
PopupMenuShowingEventArgs
PopupMenuShowingEventHandler
RankBinding
RankType
RunningTotalBinding
ScrollingMode
SelectMode
ShowFilterPanelMode
SortByCondition
SortByConditionCollection
StoreLayoutMode
SummaryDataSourceFieldNaming
SummaryFilterMode
TopBottomRuleFormatCondition
UnboundExpressionMode
UseLightweightTemplates
UserAction
WindowExpressionBinding
DevExpress.Xpf.PivotGrid.Printing
DevExpress.Xpf.Printing
DevExpress.Xpf.Printing.Parameters
DevExpress.Xpf.Printing.Parameters.Models
DevExpress.Xpf.Printing.PreviewControl
DevExpress.Xpf.Printing.PreviewControl.Bars
DevExpress.Xpf.Prism
DevExpress.Xpf.PropertyGrid
DevExpress.Xpf.Reports.UserDesigner
DevExpress.Xpf.Reports.UserDesigner.Extensions
DevExpress.Xpf.Reports.UserDesigner.Localization
DevExpress.Xpf.Reports.UserDesigner.ReportWizard
DevExpress.Xpf.Reports.UserDesigner.ReportWizard.Pages
DevExpress.Xpf.Ribbon
DevExpress.Xpf.RichEdit
DevExpress.Xpf.RichEdit.Menu
DevExpress.Xpf.Scheduler
DevExpress.Xpf.Scheduler.Drawing
DevExpress.Xpf.Scheduler.Menu
DevExpress.Xpf.Scheduler.Reporting
DevExpress.Xpf.Scheduler.UI
DevExpress.Xpf.Scheduling
DevExpress.Xpf.Scheduling.Common
DevExpress.Xpf.Scheduling.Editors
DevExpress.Xpf.Scheduling.iCalendar
DevExpress.Xpf.Scheduling.Reporting
DevExpress.Xpf.Scheduling.Visual
DevExpress.Xpf.Scheduling.VisualData
DevExpress.Xpf.SpellChecker
DevExpress.Xpf.Spreadsheet
DevExpress.Xpf.Spreadsheet.Menu
DevExpress.Xpf.Spreadsheet.Services
DevExpress.Xpf.TreeMap
DevExpress.Xpf.WindowsUI
DevExpress.Xpf.WindowsUI.Internal
DevExpress.Xpf.WindowsUI.Navigation
DevExpress.XtraRichEdit
DevExpress.XtraRichEdit.Printing
Download CHM

PivotGridXlsExportOptions Members

Contains export options specific to XLS format.

Constructors

Name Description
PivotGridXlsExportOptions() Initializes a new instance of the PivotGridXlsExportOptions class with default settings.
PivotGridXlsExportOptions(TextExportMode) Initializes a new instance of the PivotGridXlsExportOptions class with specified text export mode.

Properties

Name Description
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.
AllowCellMerge Gets or sets whether cell merging is enabled in the exported document.Only available in data-aware export mode. Inherited from XlsExportOptionsEx.
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.
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.
AllowConditionalFormattingGlyphs Inherited from XlsExportOptionsEx.
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.
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.
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.
AllowHyperLinks Gets or sets whether hyperlinks are exported.Only available in data-aware export mode. Inherited from XlsExportOptionsEx.
AllowLookupValues Gets or sets whether combo-box and lookup columns’ lookup values are exported.Only available in data-aware export mode. Inherited from XlsExportOptionsEx.
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.
AllowSparklines Gets or sets whether sparklines are exported.Only available in data-aware export mode. Inherited from XlsExportOptionsEx.
ApplyFormattingToEntireColumn Gets or sets whether cell formatting (cell appearance and borders) is applied to entire sheet columns or individual sheet cells. Formatting algorithms applied to sheet columns are faster than those applied to individual cells. Only available in data-aware export mode. Inherited from XlsExportOptionsEx.
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.
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.
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.
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.
DocumentOptions Provides access to options to be embedded as the resulting XLS or XLSX file’s Document Properties. Inherited from XlExportOptionsBase.
EncryptionOptions Provides access to the XLS and XLSX file encryption options. Inherited from XlExportOptionsBase.
ExportColumnAreaHeaders Gets or sets whether to include column field headers in the exported XLS document.
ExportDataAreaHeaders Gets or sets whether to include data field headers in the exported XLS document.
ExportFilterAreaHeaders Gets or sets whether to include filter field headers in the XLS exported document.
ExportHyperlinks This property is not supported by the XlsExportOptionsEx class. Use the XlsExportOptionsEx.AllowHyperLinks property instead.Only available in data-aware export mode. Inherited from XlsExportOptionsEx.
ExportInplaceEditorGlyphs Inherited from XlsExportOptionsEx.
ExportMode Specifies whether the document should be exported to a single or different XLS files, each page in a separate file. Inherited from XlsExportOptions.
ExportRowAreaHeaders Gets or sets whether to include row field headers in the XLS exported document.
ExportType Gets or sets the export type - WYSIWYG or Data Aware. Inherited from XlsExportOptionsEx.
FitToPrintedPageHeight Gets or sets whether the output document should be fit to the page height when printed. Inherited from XlExportOptionsBase.
FitToPrintedPageWidth Gets or sets whether the output document should be fit to the page width when printed. Inherited from XlExportOptionsBase.
GroupState Gets or sets data groups’ expanded state in the exported document. Only available in data-aware export mode. Inherited from XlsExportOptionsEx.
IgnoreErrors Specifies the document errors to be ignored in a resulting Excel file. Inherited from XlExportOptionsBase.
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.
PageRange Inherited from XlsExportOptionsEx.
RawDataMode Enables the mode that produces simple tabular data without graphic elements, style and appearance settings. Inherited from XlExportOptionsBase.
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.
SheetName Gets or sets a name of the sheet in the created XLS file to which a document is exported. Inherited from XlExportOptionsBase.
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 XlsExportOptionsEx.BandedLayoutMode option is set to Default. Only available in data-aware export mode. Inherited from XlsExportOptionsEx.
ShowColumnHeaders Gets or sets whether column headers are visible in the exported document.Only available in data-aware export mode. Inherited from XlsExportOptionsEx.
ShowGridLines Gets or sets whether worksheet gridlines are visible in the resulting XLS file. Inherited from XlExportOptionsBase.
ShowGroupSummaries Gets or sets whether group summaries are enabled in the exported document.Only available in data-aware export mode. Inherited from XlsExportOptionsEx.
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.
ShowTotalSummaries Gets or sets whether total summaries are enabled in the exported document.Only available in data-aware export mode. Inherited from XlsExportOptionsEx.
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.
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.
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.
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.
SuppressHyperlinkMaxCountWarning Inherited from XlsExportOptionsEx.
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.
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.

Methods

Name Description
Assign(ExportOptionsBase) Copies all settings from the options object passed as a parameter.
Equals(Object, Object) static Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object) Determines whether the specified object is equal to the current object. Inherited from Object.
GetHashCode() Serves as the default hash function. Inherited from Object.
GetType() Gets the Type of the current instance. Inherited from Object.
MemberwiseClone() protected Creates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
ToString() Returns a string that represents the current object. Inherited from Object.

Events

Name Description
AfterAddRow Fires immediately after a row is added to the output document.Only available in data-aware export mode. Inherited from XlsExportOptionsEx.
BeforeExportRow Fires consecutively for each control row when this row is about to be exported. Allows you to skip specific rows if they do not meet your custom criteria. Inherited from XlsExportOptionsEx.
BeforeExportTable Allows you to customize a native Excel table’s settings before export. This event is in effect when the XlsExportOptionsEx.LayoutMode property is set to Table.Only available in data-aware export mode. Inherited from XlsExportOptionsEx.
CustomizeCell Allows you to customize a PivotGrid cell in the exported XLS document. Only available in data-aware export mode.
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.
CustomizeSheetFooter Allows you to add a footer to the output document. Only available in data-aware export mode. Inherited from XlsExportOptionsEx.
CustomizeSheetHeader Allows you to add a header to the output document.Only available in data-aware export mode. Inherited from XlsExportOptionsEx.
CustomizeSheetSettings Allows you to customize the output document’s settings. Only available in data-aware export mode. Inherited from XlsExportOptionsEx.
DocumentColumnFiltering Allows you to apply filters to the exported document’s columns.Only available in data-aware export mode. Inherited from XlsExportOptionsEx.
ExportProgress Fires repeatedly while the data is being exported.Only available in data-aware export mode. Inherited from XlsExportOptionsEx.
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.
See Also