Unplanned
Last Updated: 08 May 2020 05:13 by ADMIN
Narasegowda
Created on: 05 May 2020 15:28
Category: Grid
Type: Feature Request
0
Provide Export to excel from Server side Document Processing for .NET Core

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

 

3 comments
ADMIN
Misho
Posted on: 08 May 2020 05:13

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: 
https://docs.telerik.com/aspnet-core/html-helpers/data-management/grid/export/excel-export 
https://demos.telerik.com/aspnet-core/grid/excel-export   

In case you have other questions related to Kendo UI components, please do not hesitate to contact us. 

 

Best Regards,
Misho
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
Narasegowda
Posted on: 07 May 2020 07:27

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

ADMIN
Misho
Posted on: 06 May 2020 07:04

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:

https://docs.telerik.com/aspnet-core/html-helpers/data-management/grid/export/excel-export#customizing-excel-documents 

I hope this information helps. 

Regards,
Misho
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.