This is a migrated thread and some comments may be shown as answers.

Customize Output of Treelist Excel Export

1 Answer 172 Views
TreeList
This is a migrated thread and some comments may be shown as answers.
Jonathan
Top achievements
Rank 1
Jonathan asked on 13 Sep 2017, 02:20 PM

Is it possible to directly edit the formatting of the default Excel output from the Treelist widget? Currently I am using a datasource export function to create my Excel document, however I am unable to sort the list exactly the way it appears in the widget itself without iterating through the entire datasource to sort and format as needed.

Specifically, I need to have parent items bolded with a blank line above to show grouping. Child items are displayed under parents with no blank cells tabbing the document over.

1 Answer, 1 is accepted

Sort by
0
Accepted
Stefan
Telerik team
answered on 15 Sep 2017, 08:04 AM
Hello Jonathan,

Our built-in export will export the data sorted and in the same structure as in the TreeList widget:

http://demos.telerik.com/kendo-ui/treelist/excel-export

The exported documented can be modified on the excelExport event, but due to the specific structure of the TreeList the modifications will require a lot of custom calculations:

http://docs.telerik.com/kendo-ui/api/javascript/ui/treelist#events-excelExport

Regards,
Stefan
Progress Telerik
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Tags
TreeList
Asked by
Jonathan
Top achievements
Rank 1
Answers by
Stefan
Telerik team
Share this question
or