Completed
Last Updated: 21 Jan 2021 14:17 by ADMIN
Release R1 2021
Rajendra
Created on: 26 Apr 2017 17:43
Category: Grid
Type: Feature Request
5
radgrid export to preformatted excel file
Hi

Could we have an "export to excel functionality" in "rad grid" to 
a "predefined formatted excel file".
So my excel exported file wont loose the formatting.
Thanks
1 comment
ADMIN
Peter Milchev
Posted on: 21 Jan 2021 14:17

Hello all,

I am excited to share with you that the R1 2021 release exposes overloads of the GenerateXlsxOverload method of the Grid and allow you to get the Workbook object of the to-be-exported file. Then, leveraging the SpreadProcessing Library's API you can load a template file and populate it with the data from the grid. 

You can see a live demonstration of this approach in the demo below:

Regards,
Peter Milchev
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.