Kendo Grid Export

2 posts, 0 answers
  1. Adarsh
    Adarsh avatar
    9 posts
    Member since:
    Sep 2017

    Posted 13 Oct 2017 Link to this post

    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!

  2. Preslav
    Admin
    Preslav avatar
    574 posts

    Posted 16 Oct 2017 Link to this post

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