Customize Output of Treelist Excel Export

2 posts, 1 answers
  1. Jonathan
    Jonathan avatar
    1 posts
    Member since:
    Aug 2017

    Posted 13 Sep Link to this post

    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.

  2. Answer
    Stefan
    Admin
    Stefan avatar
    1127 posts

    Posted 15 Sep Link to this post

    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.
Back to Top