Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
  [Expand]Reporting
  [Expand]Chart Control
  [Expand]Grid View
  [Expand]Card View
  [Expand]Vertical Grid
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Image and Data Browsing
  [Expand]Docking and Popups
  [Expand]Site Navigation and Layout
  [Expand]File Management
  [Expand]Multi-Use Site Controls
  [Expand]Scheduler
  [Expand]HTML Editor
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Fundamentals
   [Expand]Binding to Data
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Expand]Data Formatting
   [Expand]Layout
   [Expand]Appearance
   [Collapse]Data Export
     Export Overview
     Export to Table Formats (Data-Aware Export)
   [Expand]Design-Time Features
   [Expand]UI Elements
   [Expand]Examples
   [Expand]End-User Capabilities
   [Expand]Member Tables
  [Expand]Tree List
  [Expand]Gauges
  [Expand]Data Editors
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET 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]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Export to Table Formats (Data-Aware Export)

Data-Aware Export is an export type that is optimized for subsequent analysis of Pivot Grid's data within Microsoft Excel. This type is supported for XLS(X) and CSV formats.

The following data shaping options that are applied within the pivot grid control are retained in the output of XLS-XLSX documents.

  • Data Grouping - with the capability to collapse/expand groups within a worksheet.
  • Fixed Headers - column and row areas stay in sight.
  • Cells Formatting - exporting the number format.
  • Display Text/Value export - the capability to select whether to export display text or values.

Expanded Data-Aware Export Settings

A few options that are inherited by the XlsExportOptionsEx and XlsxExportOptionsEx classes from their base class are not supported by the data-aware export engine. The options supported in data-aware mode are listed in the following table.

Property Description
XlExportOptionsBase.SheetName Gets or sets the name of a sheet in a created XLS file to which a document is exported.
XlsExportOptionsEx.AllowFixedColumns
XlsxExportOptionsEx.AllowFixedColumns
Gets or sets whether the row area in a pivot grid control is fixed in the exported document.
XlsExportOptionsEx.AllowFixedColumnHeaderPanel
XlsxExportOptionsEx.AllowFixedColumnHeaderPanel
Gets or sets whether the column area is anchored to the top of the export document, and thus is not scrolled vertically.
XlsExportOptionsEx.AllowGrouping
XlsxExportOptionsEx.AllowGrouping
Gets or sets whether data groups are exported from the source control to the output document.
XlsExportOptionsEx.ShowPageTitle
XlsxExportOptionsEx.ShowPageTitle
Gets or sets whether a title is displayed for each print preview page of the exported document.
XlsExportOptionsEx.ExportType
XlsxExportOptionsEx.ExportType
Gets or sets export mode. You can specify WYSIWYG or data-aware export type.
XlsExportOptionsEx.GroupState
XlsxExportOptionsEx.GroupState
Gets or sets whether groups will be collapsed or expanded in the exported document.
XlExportOptionsBase.RawDataMode Enables the export mode, which when used, exports only a report's actual data to XLS(X). Note that options like XlsExportOptionsEx.AllowGrouping and XlsxExportOptionsEx.AllowGrouping are disabled and not in effect in the exported document.
XlExportOptionsBase.TextExportMode Gets or sets a value indicating whether the cells in the resulting XLS(X) document should use the same formatting as the original document.

You can customize a PivotGrid's cell in the exported XLS or XLSX document using the PivotXlsExportOptions.CustomizeCell and PivotXlsxExportOptions.CustomizeCell events. Use the CustomizePivotCellEventArgs.RowType and CustomizePivotCellEventArgs.ColumnType parameters to identify a row and a column containing the cell. To specify the cell location in the exported Excel document, use the CustomizePivotCellEventArgs.ExportArea property. To customize the cell format, use the CustomizePivotCellEventArgs.Formatting property.

Note

Set the CustomizePivotCellEventArgs.Handled parameter to true to export cells with custom formatting.

Expanded See Also

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