Kendo UI for Angular 2 Grid- export to pdf, excel

4 posts, 1 answers
  1. Graham
    Graham avatar
    16 posts
    Member since:
    Jun 2011

    Posted 01 Feb 2017 Link to this post

    Hello.

     

    I didn't find a way to export Grid to pdf. Nor I found .excel export. Could you let me know when are you going to release these features?

  2. Answer
    Dimiter Topalov
    Admin
    Dimiter Topalov avatar
    1285 posts

    Posted 03 Feb 2017 Link to this post

    Hi Graham,

    The Grid PDF and Excel export functionalities are under development. Our next big release is scheduled for May, but as stated in our Roadmap disclaimer - we are working in a dynamic environment, and things are subject to change.

    In general the respective documentation and examples for all new features and components, are available in our dedicated site as soon as they are production-ready, so you can keep an eye out for the newest features there.

    On a side note, please choose one of the threads on the subject, if you have any further questions, so we can avoid duplicates. Thank you in advance.

    Regards,
    Dimiter Topalov
    Telerik by Progress
    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.
  3. Neel
    Neel avatar
    11 posts
    Member since:
    Jul 2018

    Posted 04 Jul 2018 Link to this post

    Hello,

    I am using Lazy loading. I have approx  2 lakhs record. I want to export it to excel. Export to excel by applying grid state (GroupBy, Filter, Sort). I am able to do this task by using your given tutorial code. I have used below given typescript code to achieve this.

    public allData(): ExcelExportData {        
            if (localStorage["State"] != undefined) {
                this.state = JSON.parse(localStorage["State"]); // Apply Past Filter.

                const result: ExcelExportData = {
                    data: process(this.gridData, {
                        group: this.state.group
                        , sort: this.state.sort
                        , filter: this.state.filter
                    }).data,
                    group: this.state.group
                };
                return result;
            }
        }

     

    Now, I am facing a problem in the download. Firefox allowing me to download record but taking very long time. But chrome giving Download failed error.

    I have 60 columns and 50K records, with this facing problem. But When i run it with approx 5k record, it work fine for me in chrome. With the 5k record, I am not getting download failed error. 

    Please suggest me, what I am doing wrong and what is the best possible way to solve this issue and improve the performance of export. Export taking a long time might be due to lazy loading. If you can help with this. It would b wonderful.     

     

     

  4. Svetlin
    Admin
    Svetlin avatar
    460 posts

    Posted 06 Jul 2018 Link to this post

    Hi Neel,

    In general, when we export such large data sets it is expected, that the browser could hang. There are factors outside of our control, that apply to the excel export functionality like the system and browser-specific limit. This is why, we highly recommend the implementation of a server side solution when exporting large data sets as described in the limitations section of the Excel Export:
    https://www.telerik.com/kendo-angular-ui/components/excelexport/#toc-known-limitations

    and here

    https://www.telerik.com/kendo-angular-ui/components/grid/export/excel-export/#toc-known-limitations

    For a server side solution we could use the RadPdfProcessing library or any other tool.

    I hope this provides some more information.

    Regards,
    Svetlin
    Progress Telerik
    Try our brand new, jQuery-free Angular 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