This is a migrated thread and some comments may be shown as answers.

Hyperlink in ExcelML Output

5 Answers 53 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Cheston Williams
Top achievements
Rank 1
Cheston Williams asked on 15 Jul 2008, 01:50 PM
I am outputting my grid in ExcelML format.  Is it possible to add a hyperlink to the cells?

5 Answers, 1 is accepted

Sort by
0
Cheston Williams
Top achievements
Rank 1
answered on 15 Jul 2008, 01:54 PM
I forgot to mention that I have ExportOnlyData set to True.
0
Accepted
Rosen
Telerik team
answered on 16 Jul 2008, 07:01 AM
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
0
Cheston Williams
Top achievements
Rank 1
answered on 16 Jul 2008, 02:41 PM
Thank you.  This was just what I needed.
0
Chris
Top achievements
Rank 1
answered on 16 Jul 2008, 03:53 PM
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
0
Cheston Williams
Top achievements
Rank 1
answered on 17 Jul 2008, 01:34 AM
Chirs,

Look at the Exporting tips and tricks page for help on what you want to do.
Tags
Grid
Asked by
Cheston Williams
Top achievements
Rank 1
Answers by
Cheston Williams
Top achievements
Rank 1
Rosen
Telerik team
Chris
Top achievements
Rank 1
Share this question
or