PivotXlsExportOptions Properties

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

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 the column field headers in the XLS exported document. Inherited from PivotXlsExportOptionsBase.
ExportDataAreaHeaders	Gets or sets whether to include the data field headers in the XLS exported document. Inherited from PivotXlsExportOptionsBase.
ExportFilterAreaHeaders	Gets or sets whether to include the filter field headers in the XLS exported document. Inherited from PivotXlsExportOptionsBase.
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 the row field headers in the XLS exported document. Inherited from PivotXlsExportOptionsBase.
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.