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