I need to export Gridview data to excel file and achieved the export function using attached code,everything is ok but the content of the excel file to which gridview data exported Contained all Web components, sush as button,textbox,etc. I
want to know how to filter those web components. The Code is following,Please help me,thanks.
If DataEmpty = False Then
Dim dt As DateTime = Now()
Dim Filename As String = dt.ToString("yyMMddhhmmss")
Filename = "UserReport_" + Filename + ".xls"
GridView_UserList.AllowPaging = False
GridView_UserList.Columns(0).Visible = False
GridView_UserList.DataSource = BindData()
GridView_UserList.DataBind()
GridView_UserList.HeaderRow.BackColor = ...
Go to the complete details ...