export data grid hyperlink column to excel
hi there,
i have problem to export datagrid hyperlink column to excel. Right now i am using datagrid properties to create hyperlink. When I export to excel, the common column ok, but for hyperlink column the value is null. Can someone help me..
Here the code i used
Dim DemoGridItem As DataGridItem
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
Response.Write("<tr><td>HYPERLINK COLUMN")
For Each DemoGridItem In DataGrid1.Items
Response.Write("<td>" & DemoGridItem.Cells(3).Text)
Next
Response.Write("</table>")
Response.End()
Thank You
|