exporting hyperlink to excel

[Dan]

Hello,

I have read the other threads, and I am not having much success. I can export a URL as text, but I haven't been able to get it to show up as a clickable link in an xlsx file. Can someone please help me? Below are the examples preceded by a note about its behavior:

 

[ This one doesn't show anything in the text cell. I read on an old post that this is to be expected. ]
<telerik:GridHyperLinkColumn AllowFiltering="False" AllowSorting="False" Visible="true"
 HeaderText="View0.0"
 Text="View Page"
 Target="_blank"
 DataNavigateUrlFormatString="page.aspx?autoid={0}"
 DataNavigateUrlFields="SpecimenAutoID">
    <HeaderStyle Width="50px" HorizontalAlign="Center"></HeaderStyle>
</telerik:GridHyperLinkColumn>

[This displays the cell as source html.]
<telerik:GridTemplateColumn HeaderText="View1.0" >
    <ItemTemplate>
        <a href="https://www.google.com">Click here to open the folder</a>
    </ItemTemplate>
    <HeaderStyle Width="200px" HorizontalAlign="Center"></HeaderStyle>
</telerik:GridTemplateColumn>

[This displays the cell as source html.]
<telerik:GridTemplateColumn HeaderText="View1.1" >
    <ItemTemplate>
        <a href="https://www.google.com">https://www.google.com</a>
    </ItemTemplate>
    <HeaderStyle Width="200px" HorizontalAlign="Center"></HeaderStyle>
</telerik:GridTemplateColumn>

 

[This displays the link as a text string.]
<telerik:GridTemplateColumn HeaderText="View1.2" >
    <ItemTemplate>
        https://www.google.com
    </ItemTemplate>
    <HeaderStyle Width="200px" HorizontalAlign="Center"></HeaderStyle>
</telerik:GridTemplateColumn>

[This displays the data field as text string]
<telerik:GridBoundColumn Visible="false" SortExpression="directURL" HeaderText="View Specimen" HeaderButtonType="TextButton"
                         DataField="directURL" Exportable="True" UniqueName="hiddenDirectURL" >
    <HeaderStyle Width="200px" HorizontalAlign="Center"></HeaderStyle>
</telerik:GridBoundColumn>

Any suggestions would be appreciated. Thanks.

Dan

 

[Doncho]

Hi Dan,

Thank you for the samples provided!

When the required export format is XLSX, some additional customization of the export is needed.

Exporting to XLSX format is based on the TelerikProcessing Libraries. Therefore, the RadSpreadProcessing library could be the best place to look for an answer. Here are some articles that may help in solving the case:

• RadGrid | XLSX Export
• RadGrid | Integration with Telerik Document Processing Library
• RadSpreadProcessing | Hyperlink

On the other hand, when exporting to Excel HTML format exporting links is done automatically. You can try the sample project provided in this forum thread - Editting GridHyperLinkColumn NavigateUrl in codebehind

Please go through the suggested articles and let me know if they help.

Kind regards,
Doncho
Progress Telerik