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

Thinking Out Loud
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...

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.
No Comments

Please login or register to post comments.