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";