DevExpress Dashboard - Excel Export & Excel Data Binding (Coming soon in v15.2)

Thinking Out Loud
18 November 2015

As you all know, Microsoft Excel plays a significant role in business and so with our upcoming release, DevExpress Dashboard will introduce Microsoft Excel data export support. Simply said, you'll now be able to export the contents of the following Dashboard items to Excel.

  • Charts
  • Scatter Charts
  • Grids
  • Pie Charts
  • Cards
  • Gauges
  • Pivot Tables
  • Choropleth Map
  • Geo Point Maps
  • Range Filters

Here's an example of a Grid Dashboard Item with Sparklines exported to XLSx.

DevExpress Dashboard Data Export

Note: DevExpress Dashboard preserves original data formats during export (Custom, Currency, Date, Time, etc).

It's painless to export data - simply select the Export to Excel menu item for the Dashboard Item you wish to export.

DevExpress Dashboard - Export to Excel

Binding to Microsoft Excel Workbooks and CSV Files

DevExpress Dashboard v15.2 allows you to load data from Microsoft Excel workbooks and CSV files. You can select everything in a worksheet or a cell range referenced by a defined table or name.

  1. Select Microsoft Excel workbook / CSV file as  you data source type.
  2. Locate the required workbook.
  3. Specify import settings.
  4. Select a worksheet, table or specified range.

Free DevExpress Products – Get Your Copy Today

The following free DevExpress product offers remain available. Should you have any questions about the free offers below, please submit a ticket via the DevExpress Support Center at your convenience. We’ll be happy to follow-up.
J Joubert
J Joubert

This is a great feature. Thanks

18 November 2015
Bassam Abdelaal
Bassam Abdelaal

This is a super improvement , users asked about excel export for charts for sometime , thank you for great work

19 November 2015
Ray Navasarkian (DevExpress)
Ray Navasarkian (DevExpress)

Just to avoid any misunderstanding, this is a data export feature - We don't actually integrate with Excel's Chart/Pivot Tables.

20 November 2015
Cory Crooks
Cory Crooks

Is this for both Web and Desktop dashboards?

22 November 2015
John John Smith
John John Smith

Do you have any great code samples that I could use?  I'm using IQueryables and the MVC GridView Control.

Endless Paging, with filters, groupings, etc.

We export to Excel and CSV often...

14 March 2016

Please login or register to post comments.