To export to excel a datatable, I use the follwoing piece of code:
The last column has hyperlink tags data like this in the same cell with coma delimiter.
<a href='http://localhost:9997/Planicom/reports/WLLHyperlinkedData.aspx?e=Arbon'>Arbon'</a>,<a href='http://localhost:9997/Planicom/reports/WLLHyperlinkedData.aspx?e=Carlton>Carlton</a>,
The problem is I do not get the hyperlink in excel. It is like text only. Any ide how to fix this?
void ExportDataSetToExcel(System.Data.DataTable table, string filename)
{
System.Web.HttpResponse response = Page.Response;
Response.Cache.SetExpires(DateTime.Now.AddSeconds(1));
Response.Cache.SetCacheability(HttpCacheability.NoCac ...
Go to the complete details ...