[Solved] How to add footer during Excel Export !

[Kannan]

Hi,

I'm using Telerik GridView. I'm exporting the grid data to excel by calling gridView.ToHtml();

This exports the data which is displayed in the grid.

Apart from this I need to add few more rows having some text. Is it possible to do so ?

If so please let me know. Thank You !

Thanks & Regards,
Kannan

[Rossen Hristov]

Hello Kannan T,

The GridViewDataControl.ToHtml() method returns a string with the HTML. Add the few rows having some text at the end of this string.

Greetings,
Ross
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Kannan]

Hi Ross,

Thanks. I hope you mean by adding few more rows using <tr><td></td></td> inside <table> ?

This is fine. But Is it possible to export the grid in excel format like Microsoft Excel interop do? Because I need to add data in 1 or more work sheets.

Kindly let me know how to do this in telerik ?

Thanks & Regards,
Kannan

[Vlad]

Hi,

Currently only HTML and ExcelML formats are supported.

Kind regards,
Vlad
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.