Show theme settings Shopping cart Download trialFree Trial
Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

Export

Page 1 of 9 (85 items)Prev123456789Next
Drop Filter Fields Here
Page 1 of 9 (85 items)Prev123456789Next
Export Settings
v
Export
Data Aware Options
Field Header Options
Field Values Options

This demo demonstrates how to easily export data in WYSIWYG (What You See Is What You Get) or Data-Aware modes. Data can be exported to a file or stream in the following formats:

However, exporting to table formats (XLS, XLSX, and CSV) is performed in Data-Aware mode by default. You can specify the default mode for all methods exported to the Excel format or for each of them. To change the default mode for all methods that support DataAware, use the ExportSettings.DefaultExportType property. To change an export type with each call, create an XlsExportOptionsEx object (or XlsxExportOptionsEx, CsvExportOptionsEx objects), set its ExportType property to the ExportType.DataAware or ExportType.WYSIWYG value and pass this object to the ExportTo... method.

To export ASPxPivotGrid data, create an ASPxPivotGridExporter control instance in addition to ASPxPivotGrid and assign ASPxPivotGrid's ID to the ASPxPivotGridExporter.ASPxPivotGridID property value.


See Also:
Collapse/Expand
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
Open VB Solution
The source code files for this demo are installed (by default) in the following directories:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\ASPxPivotGridDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxPivotGridDemos

Your Next Great ASP.NET App Starts Here

Get started today and download your 30-day trial of ASP.NET Controls and Libraries (includes 30 days of free technical support).
All demos ship with full source code and are included in the DevExpress ASP.NET distribution. Refer to the Demos and Sample Applications topic to learn more.

DevExpress ASP.NET Controls and Libraries ship as part of DevExpress Universal, DXperience and ASP.NET Subscriptions and are backed by a 60 day unconditional money-back guarantee.
To learn more and obtain pricing information, visit the Compare Features and Pricing webpage. For immediate assistance, contact us by Email at info@devexpress.com or by phone at +1 (818) 844-3383 between 7:30am and 4:30pm Pacific Time.