add extra cell's in Gridview

[Andreas Url]

Hey guy's,


I need to export extra cell`s in my excelsheet, which are not found in gridview. The position of this cells have to be on the top of the page. I've attached an example, i hope you could follow.

Thanks for efforts.

kind regards

Url Andreas

[Daniel]

Hello Andreas,

Can you please specify whether you use the ExcelML or the HTML format? This way I will be able to provide to-the-point suggestion.
ExcelML basics
Word/Excel export (HTML-based)

Best regards,
Daniel
the Telerik team

[Andreas Url]

Hello Daniel,

The first solution i tried was with the "Microsoft.Office.Interop.Excel" namespace. And it worked great on the developing machine.
After export on a webspace, the export function didn`t work. now i need the best solution for this problem.

I`ve got a DataGrid, and the standard export via export button works, but i´ve got only the list form gridview, I also need the amount of some values at the top oft the page. So I´m sorry i can`t tell you wich solution is the best, i hope you can help me.

regards

Andreas

[Daniel]

Hello Andreas,

It is possible to add custom information on top of RadGrid. For the HTML format you should handle the GridExporting event and then manually insert the HTML code representing the aforementioned values. For the ExcelML format you will have to alter the XMLSS structure (in the ExcelMLRowCreated event) by inserting a RowElement above the other items.

Regards,
Daniel
the Telerik team