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

Kendo Grid Export

1 Answer 60 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Adarsh
Top achievements
Rank 1
Adarsh asked on 13 Oct 2017, 03:39 PM

I have two questions on Kendo Grid Export (using ASP.Net MVC)

 

1) I have 2 kendo grids on a single ASP.NET MVC page. I wanted to export data from both the grids to a single worksheet in excel.

As per the below code, data is getting exported to two worksheets (2 tabs) in a single excel file. I wanted to have the data displayed in a single worksheet instead of 2 worksheets.

 var sheets = [
                       productsWorkbook.sheets[0],
                       ordersWorkbook.sheets[0]
                     ];
                     sheets[0].title = "XXX_DataView";
                     sheets[1].title = "YYY_DataView";
                     var workbook = new kendo.ooxml.Workbook({
                         sheets: sheets
                     });
                     kendo.saveAs({
                         dataURI: workbook.toDataURL(),
                         fileName: "XXX_YYY_DataView.xlsx"

 

2) Is there any limit on data export to PDF. We have difficulty in exporting more than 6000 rows of data to PDF. Please let us know how we can get this resolved.

 

Appreciate your faster response. Thanks!

1 Answer, 1 is accepted

Sort by
0
Preslav
Telerik team
answered on 16 Oct 2017, 01:18 PM
Hello Adarsh,

Straight to the answers.

1) To export multiple grids to excel, I would suggest following the approach outlined in this article:
2) Generally speaking, exporting big amount of data should be done on the server side. For this purpose, you could use any third party library that fits your needs. 

Additionally, you might be interested in checking the "Export Grid Data in PDF" how-to article:
Regards,
Preslav
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.
Tags
Grid
Asked by
Adarsh
Top achievements
Rank 1
Answers by
Preslav
Telerik team
Share this question
or