Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel sheet problem
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing from Excel Sheet Problem | Excel Discussion (Misc queries) | |||
Importing Excel Sheet Problem | Excel Programming | |||
problem in excel sheet | Excel Programming | |||
Excel sheet copy problem | Excel Programming | |||
Problem: How to copy excel sheet in C++ | Excel Programming |