WPF TreeList Control - Excel Data Export (Coming soon in v16.1)

02 June 2016

Over the last couple of release cycles, we've done quite a bit of work to improve our support for Microsoft Excel - specifically how we export data to Excel from our UI controls. With v16.1, our WPF TreeList has been enhanced so that it fully supports our Excel Data Export Engine. For those of you unfamiliar with this control, our TreeList is a hybrid - both a tree and a list in one. It's a great alternative to a standard TreeView when you want to display extended information for your hierarchical data.

Exporting TreeList Data to Excel

WPF TreeList - Export to Excel

When it comes to data export to Excel, the following TreeList settings are maintained during all export operations:

Node State: retains the ability to expand/collapse nodes within the worksheet.
Data Sorting and Filtering: data is displayed as it appeared within the TreeList.
Totals and Summaries: including the ability to modify/change formulas.
Excel Style Format Rules (Illustrated in the image above)
Data Validation for Lookup and Combo-box Columns
Fixed Columns

As always, we want to hear your thoughts...tell us how you're using our Excel Data Export Engine in your apps...


1 comment(s)
Raoulw

Hi Ray,

The work is appreciated but IMO DX always focuses on the bells and whistles too much and forget what end users do with the export.

The only reason people export data to excel is to do further analysis on it. And that is in some cases not possible. For example:

www.devexpress.com/.../T325668

www.devexpress.com/.../T319975

Thanks,

Raoul.

5 June, 2016

Please login or register to post comments.