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

[Graham]

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?

[Dimiter Topalov]

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

[Neel]

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.     

 

 

[Svet]

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