How to export to excel with hyper link

[Graeme]

Hi,

I used this follow function to export my grid to Excel format, while my data source(a store procedure) has hyperlink inside.

How can I just export the grid without hyperlink by setting some configurations?

aspx file

<asp:GridView ID="ExcelGridView" runat="server" BorderStyle="None"  GridLines="Both" Visible="False"  HeaderStyle-Font-Bold="true" HeaderStyle-BackColor="LightGray" OnRowDataBound="ExcelGridView_RowDataBound"></asp:GridView>

 

 

cs file

System.Data.DataTable data_table = ADOHelper.GetDataTable(ConfigurationManager.ConnectionStrings["Ligx_4_DB"].ConnectionString, query, null);
ExcelGridView.DataSource = data_table;
ExcelGridView.DataBind();
ExcelGridView.Visible = true;
Response.ClearContent();
string attachment = "attachment; filename=ExcelDownload.xls";
Response.AddHeader("Content-disposition", attachment);
Response.ContentType = "xls";

 

[Eyup]

Hello Russell,

I've already replied to your query in the formal support ticket. I suggest that we continue our technical conversation on the mentioned thread.

Regards,
Eyup
Progress Telerik

[jose]

Hi Rusell

You solve this issue and how?

 

Regards!

[Attila Antal]

Hi Jose,

To export the HTML content to excel, you can use the Excel-Format="Html". This can export the complete Grid structure into a prior 2007 version of the Excel (XLS) file.

If you want to do the same but for version 2007 and later (XLSX), you will need to set the Excel Format to "Xlsx" and implement a solution that uses additional libraries such as the Telerik Document Processing Libraries (DPL).

Here is a Knowledge Base article with an example: Export to Excel XLSX with Hyperlinks

Regards,
Attila Antal
Progress Telerik