Hi I have a Rad Grid View that I am exporting to excel using the code below. This works fine, but I would like the code to export the grouped data so that excel sees it as grouped data rather than static cells. Is there a way to achieve this?
Thanks in advance.
7 Answers, 1 is accepted
Currently, we do not support the row grouping feature in Excel and all group rows are exported as static cells. However, this is a nice feature and I added it in our issue tracking system. You can track its status by using the following link. I updated also your Telerik points.
Should you have any other questions, do not hesitate to ask.
the Telerik team
Thank you for writing.
You can track the feature request's progress, subscribe for status changes and add your vote/comment to it on the following link - feedback item. Since we have already introduced the Document processing library in the Telerik UI for WinForms suite, we will consider this feature in the next releases.
I hope this information helps. Should you have further questions, I would be glad to help.
Being Apache licensed if you use NPOI you should include a text file on your executable folder citing the authors of POI and NPOI.
If the above is not a problem you can check out the attached file, I know it still need refactoring and is not well tested yet but might be a good starting point, I share that code with you or who other might be interested, as is with no guarantee or whatever: I am not linked with Telerik, I'm a simple user of their beautiful library, if you want to use my code to build your, do it.
The output excel file is in compatible xls binary format, shows group, filtered and hidden columns. It try to set the column width equals to the column width of the grid and to use the same grid font.
The algorithm to calculate the column width could be improved, for the moment the approach was to check out which effective measure shows excel for each measure used in input.
Never tried on hi-res monitor, only tested for default telerik grid template, but for the moment few users are happy of the result.
Thank you very much. I will try your code and hope to have good result!
Thank you for writing.
@Andrea I have updated your Telerik points for community effort.