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

Exporting to Different Formats

  • Export to PDF
  • Export to XLS
  • Export to XLSX
  • Export to DOCX
  • Export to RTF
  • Export to CSV
Product Name Ascending
Company Name 
Order Date 
Product Amount 
CollapseProduct Name: Alice Mutton (Sum=$30,911.40, Count=37) (Continued on the next page)
 Antonio Moreno Taquería6/19/2019$702.00
 Berglunds snabbköp2/12/2019$312.00
 Blondesddsl père et fils7/25/2018$936.00
 Bólido Comidas preparadas12/29/2019$1,170.00
 Bon app'2/5/2020$592.80
 Bottom-Dollar Markets3/13/2020$234.00
 Bottom-Dollar Markets3/13/2020$234.00
 Du monde entier2/16/2020$585.00
 Ernst Handel12/24/2019$1,023.75
 Count=2,155 Sum=$1,233,520.14
Page 1 of 224 (2232 items)Prev1234567222223224Next
Note: If you export grouped data to RTF, be sure to open the resulting file with an editor that fully supports RTF, including tables. For instance, Microsoft WordPad does not support this feature, and thus the file may appear corrupt.

The DevExpress ASP.NET Grid View (ASPxGridView) allows you to export data with ease. Data can be exported to a file or stream in PDF, RTF, CSV, XLS, XLSX, and DOCX formats. You can either rely on the grid's built-in UI or use the client and server APIs in code.

The ASPxGridView toolbar implements the following commands to export grid data: `ExportToPdf`, `ExportToXls`, `ExportToXlsx`, `ExportToDocx`, `ExportToRtf`, and `ExportToCsv`. Populate a grid toolbar with a GridViewToolbarItem object and set its Command property to an export command to add the corresponding item to the toolbar.

The export commands and the client API are disabled for security reasons (the default setting). To enable this functionality, set the EnableClientSideExportAPI property to `true`.

In this demo, export to table formats (XLS, XLSX, and CSV) is performed in the WYSIWYG (What You See Is What You Get) mode. Therefore, the table formatting, e.g., grouping, is lost and grid summaries are converted to strings. However, you can maintain such information by exporting grid data in the DataAware mode. You can see this functionality in the Excel Data Aware Export demo.

To learn more about data export in Grid View, refer to the Export Grid View Data help topic.

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\ASPxGridViewDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxGridViewDemos