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

Format Column headers of Grid Before Exporting to Excel

3 Answers 193 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Sripriya
Top achievements
Rank 1
Sripriya asked on 06 Jul 2015, 06:37 AM

Hi, 

We are having a grid which should be exported to Excel. As this grid contains large data we are slanting the grid header columns to an angle.

So when we export this data to excel, we would like to rotate the header columns to 90 degrees. We have gone through this link

http://docs.telerik.com/kendo-ui/api/javascript/ooxml/workbook#configuration-sheets.rows.cells but couldnt find the help we need.

Can you help us on this?

 

Regards

Sripriya

3 Answers, 1 is accepted

Sort by
0
Dimiter Madjarov
Telerik team
answered on 06 Jul 2015, 07:37 AM

Hello Sripriya,

Rotating the text in the exported sheet is currently not supported and there is no suitable workaround that we could suggest.

Regards,
Dimiter Madjarov
Telerik
 
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
 
0
Konstantin
Top achievements
Rank 1
answered on 08 Aug 2019, 10:00 AM

Hi, 

Is this feature supported now?

0
Alex Hajigeorgieva
Telerik team
answered on 12 Aug 2019, 08:08 AM
Hi, Konstantin,

We already have a logged feature request to make it possible to rotate the cell content and I have added a vote on your behalf and on behalf of Sripriya here:

https://feedback.telerik.com/kendo-jquery-ui/1359213-support-text-orientation-in-the-export-to-excell-feature

It looks like this feature has potentia. Since new functionalities are implemented based on demand and popularity of our clients,the more popularity it gains, the sooner it will be pushed forward for implementation.

Meanwhile, for other header row customizations, you could check out this knowledge base article:

https://docs.telerik.com/kendo-ui/knowledge-base/grid-excel-export-custom-headers

Kind Regards,
Alex Hajigeorgieva
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.
Tags
Grid
Asked by
Sripriya
Top achievements
Rank 1
Answers by
Dimiter Madjarov
Telerik team
Konstantin
Top achievements
Rank 1
Alex Hajigeorgieva
Telerik team
Share this question
or