Kendo Grid Export

[Adarsh]

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!

[Preslav]

Hello Adarsh,

Straight to the answers.

1) To export multiple grids to excel, I would suggest following the approach outlined in this article:

• https://docs.telerik.com/aspnet-mvc/helpers/grid/how-to/Export/multiple-grid-export

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:

• https://docs.telerik.com/aspnet-mvc/helpers/grid/how-to/Export/pdf-export-server-side

Regards,
Preslav
Progress Telerik