Need to export to excel & pdf with custom grid styles & cell formatting

Jun 10, 2014 at 7:33 AM
Edited Jun 10, 2014 at 7:33 AM
Hi,
I need to export the grid contents to excel & pdf with custom grid styles & cell formatting. Also is it possible to export with grouping struture & have grid header inside the expander.

Image

Thanks
Selva Kumar
Coordinator
Jun 10, 2014 at 8:01 AM
You will to to do custom inerop operation to do it after export to excel method is called.
Its not that hard.
Jun 10, 2014 at 8:15 AM
Edited Jun 10, 2014 at 8:16 AM
Thanks for the quick reply.
Can you explain me in detail or share a link..
Also is it possible to have a header inside the grouping like this.

Image


Thanks a lot
Selva
Coordinator
Jun 10, 2014 at 8:32 AM
Color you can see this link: http://www.e-iceblue.com/Knowledgebase/Spire.XLS/Demos/RichText/Excel-Text-Color-for-C-/VB.NET.html

Once color is applied you can use the group by feature of excel.

Start the macro and do grouping stop the macro, visit the macro code , and apply same logic in C# (I had done this long time back and it works.)
Jun 10, 2014 at 9:11 AM
Thanks, hope it will help to solve the issue..
If you have any sample code it will be very helpful for me..Thanks once again
Coordinator
Jun 10, 2014 at 9:59 AM
Ni I dont have code that now , long time back I did it,