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

Exporting large Kendo grid dataset

9 Answers 2028 Views

Grid

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

9 Answers, 1 is accepted

answered on 13 Jul 2018, 01:43 PM

Hello,

Since the data is already available to you on the server, perhaps you may have a look at the Server Export demo at:

https://demos.telerik.com/aspnet-mvc/grid/server-export

If you look at the .cshtml file, the button click sends only the columns configuration to the backend:

$(".download").click(function () {

var grid = $("#Grid").data("kendoGrid");

$("#export-model").val(encodeURIComponent(JSON.stringify(grid.columns)));

});

Then, change tab and you will see that the columns received from the client are used to build the spreadsheet on the server and are parsed to a list of the ExportColumnSettings class:

var columnsData = JsonConvert.DeserializeObject<IList<ExportColumnSettings>>(HttpUtility.UrlDecode(model));

This is almost identical to the demo I referenced in my previous response, where the model is mapped to a custom class:
https://github.com/telerik/ui-for-aspnet-mvc-examples/blob/master/grid/grid-dpl-integration/GridExcelSpreadProcessing/Controllers/StreamController.cs#L20

var modelObject = JsonConvert.DeserializeObject<IList<ColumnSettings>>(model);

Both of the projects are available to you and both are runnable so you may debug them and put breakpoints where desired - the one in the repository is open to the public and the one in our online demos is part of our distribution:

// Controller:

~telerik.ui.for.aspnetmvc.[VERSION].commercial\wrappers\aspnetmvc\Examples\VS2015\Kendo.Mvc.Examples\Controllers\Grid\Server_ExportController.cs

// View:

~telerik.ui.for.aspnetmvc.[VERSION].commercial\wrappers\aspnetmvc\Examples\VS2015\Kendo.Mvc.Examples\Views\gridserver_export.cshtml

https://www.telerik.com/account/product-download?product=KENDOUIMVC

Regards,
Alex Hajigeorgieva
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.

answered on 28 Sep 2018, 04:19 AM

Hi Alex Hajigeorgieva,

Good Day, I hope you will consider my question in this thread.

I'm having the same problem with downloading xlsx file from kendo ui grid. I am using Kendo UI for JQuery. Is there a way to export large dataset from kendo grid using this library instead of using Kendo UI for MVC?

Current Code:

//this kendo Grid will return 100k + rows

$("#myTable").kendoGrid({
toolbar: ["excel"],
excel: {
fileName: "Trade Reports.xlsx",
filterable: true,
allPages: true,
},

Thank You,

answered on 02 Oct 2018, 10:13 AM

Hi Angelo,

You can use the same approach like in the MVC example for submitting the relevant information to the server. There, the excel file can be generated and returned to the client.

Also, you can specify a proxy in the excel export options. Specify the excel.proxyURL option to define the URL that will stream the file to the client-side. Then set the excel.forceProxy option to make sure that the proxy is always used.

Regards,
Viktor Tachev
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.