Hi Team ,
I Am trying to export kendo grid content from Server side as i need to do some modification(View model) before exporting to excel. and also i need to add some custom headers while exporting.
Can you please provide me the solution with example with this scenario.
Thanks,
Narasegowda
Hi,
The Server side export to excel functionality of the Grid widget is currently supported for the ASP.NET MVC product. Here is the demo: https://demos.telerik.com/aspnet-mvc/grid/server-export
As you could see in the server_export controller it depends on the Kendo.Mvc.Export assembly. Providing this feature for ASP.NET Core depended on porting Telerik Document Processing Library to ASP.NET Core, which is now complete. Thus, providing the same export functionality for ASP.NET Core Grid is included in our future plannings. We have it in our roadmap but at this point cannot say an exact time frame when the new version of the library will be released. I've converted this ticket to feature request for this functionality in Telerik UI for ASP.NET Core feedback portal, which will help us track the demand for this feature and prioritize its implementation against other features.
The ASP.NET Core suite currently includes Grid widget that you can use it in your applications with client-side export for the time being:
Best Regards,
Misho
Progress Telerik
Hi Misho,
Thank you for the response.
When the AllPages option is set to true, the Grid makes a read request for all data. If the data items are too many, the browser may become unresponsive.
So I wanted to Implement server side processing. Already went through below link. https://docs.telerik.com/devtools/document-processing/libraries/radspreadstreamprocessing/export
Its not that helpful as there is not much details provided for implantation.
Can you please create a sample project where we should able to export to excel with huge data from server side.
And also we want to add custom headers and column with style..
Note: Please provide the Prerequisites for Server side export to excel.
Thanks,
Narasegowda
Hello,
We have the following demo which shows how to enable and use the Export to Excel functionality of the Telerik for ASP.NET Core Grid:
https://demos.telerik.com/aspnet-core/grid/excel-export
The following article demonstrates how to customize the exported excel documents, e.g. the background of the row cells:
I hope this information helps.
Regards,
Misho
Progress Telerik