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

Excel Data Aware Export

v
  • Export to XLS
  • Export to XLSX
  • Export to CSV
  •  
    ...
Category Name Ascending
Product Name 
Quantity Per Unit 
Unit Price 
Units In Stock 
Total 
CollapseCategory Name: Beverages
 Chai10 boxes x 20 bags$18.0039$702.00
 Chang24 - 12 oz bottles$19.0017$323.00
 Guaraná Fantástica12 - 355 ml cans$4.5020$90.00
 Sasquatch Ale24 - 12 oz bottles$14.00111$1,554.00
 Steeleye Stout24 - 12 oz bottles$18.0020$360.00
 Côte de Blaye12 - 75 cl bottles$263.5017$4,479.50
 Chartreuse verte750 cc per bottle$18.0069$1,242.00
 Ipoh Coffee16 - 500 g tins$46.0017$782.00
 Laughing Lumberjack Lager24 - 12 oz bottles$14.0052$728.00
 Outback Lager24 - 355 ml bottles$15.0015$225.00
 Rhönbräu Klosterbier24 - 0.5 l bottles$7.75125$968.75
 Lakkalikööri500 ml$18.0057$1,026.00
  Count=12   Sum=$12,480.25
ExpandCategory Name: Condiments
  Count=12   Sum=$12,023.55
ExpandCategory Name: Confections
  Count=13   Sum=$10,392.20
  Count=77   Sum=$74,050.85
Page 1 of 2 (20 items)Prev12Next

The ASPxGridView can export data in both XLS and XLSX formats. The DevExpress Excel Export Engine maintains data grouping layout and automatically transforms summary items to corresponding Excel functions.

The Export row type combo box controls the ExportSelectedRowsOnly property value and specifies whether all rows displayed within the ASPxGridView are exported (or only selected rows).

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

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.