Hyperlink in ExcelML Output

[Cheston Williams]

I am outputting my grid in ExcelML format.  Is it possible to add a hyperlink to the cells?

[Cheston Williams]

I forgot to mention that I have ExportOnlyData set to True.

[Rosen]

Hello Cheston,

You can easily add links to ExcelML export sheet, by hooking to the RadGrid's ExcelMLExportRowCreated event. There you can find the appropriate cell and add to it a HRef attribute with the url as a value. I have attached a simple page in which is demostrated this approach. Please give it a try and see if it helps.

Greetings,
Rosen
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Cheston Williams]

Thank you.  This was just what I needed.

[Chris]

Hi,

If I export to Excel output (not ExcelML), currently I have a telerik:GridHyperLinkColumn which displays no content in the excel spreadsheet while I set the ExportOnlyData=true even tho I set the column visible=true. 

1. How do I make the content to be able to be displayed from the HyperLinkColumn?

2. If I set ExportOnlyData=false, I can see all the HyerLinkColumn without any problem, but is it possible to make it no clickable or hyperlinkable inside the excel spreadsheet?

Chris

[Cheston Williams]

Chirs,

Look at the Exporting tips and tricks page for help on what you want to do.