K
KK
Hi,
I am using Response object in vb.net to download an excel sheet with
data.
It worked well and I could download excel file with data. But suddenly
It started downloading only blank excel sheet. even though the data
exists. Do I need to do any refreshing? or do I need to re-start IIS?
Dim dt As DataTable = DSCAG.Tables(0)
Dim strFileName As String = "Downloadfile.xls"
Response.Clear()
Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader("Content-Disposition", "attachment;
filename=""" & strFileName & """")
Response.ContentEncoding = System.Text.Encoding.UTF7
Response.Charset = ""
EnableViewState = False
Dim oStringWriter As New System.IO.StringWriter
Dim oHTMLTextWriter As New
System.Web.UI.HtmlTextWriter(oStringWriter)
DGCAGReference.DataSource = dt
DGCAGReference.DataBind()
DGCAGReference.RenderControl(oHTMLTextWriter)
Dim strResponse As String = oStringWriter.ToString
strResponse = strResponse.Replace("</td>", " </td>")
Response.Write(strResponse)
I have noticed that in the blank excel sheet the excel sheet name is
".xls]Downloadfile[1]". I don't understand why the excel sheet name is
like that.
any ideas?
Thanks.
I am using Response object in vb.net to download an excel sheet with
data.
It worked well and I could download excel file with data. But suddenly
It started downloading only blank excel sheet. even though the data
exists. Do I need to do any refreshing? or do I need to re-start IIS?
Dim dt As DataTable = DSCAG.Tables(0)
Dim strFileName As String = "Downloadfile.xls"
Response.Clear()
Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader("Content-Disposition", "attachment;
filename=""" & strFileName & """")
Response.ContentEncoding = System.Text.Encoding.UTF7
Response.Charset = ""
EnableViewState = False
Dim oStringWriter As New System.IO.StringWriter
Dim oHTMLTextWriter As New
System.Web.UI.HtmlTextWriter(oStringWriter)
DGCAGReference.DataSource = dt
DGCAGReference.DataBind()
DGCAGReference.RenderControl(oHTMLTextWriter)
Dim strResponse As String = oStringWriter.ToString
strResponse = strResponse.Replace("</td>", " </td>")
Response.Write(strResponse)
I have noticed that in the blank excel sheet the excel sheet name is
".xls]Downloadfile[1]". I don't understand why the excel sheet name is
like that.
any ideas?
Thanks.