Problem with Open Save dialog and excel

Michael Groeger · Feb 15, 2006

Hi,

I have an aspx page which generates an excel document and transfers it to
the browser as attachment. Normally, once the document is transferred the
open save dialog prompts to open or save the excel document. When I click
save I can save the excel document or when I click open it directly opens in
excel. This works fine for all but one machine.

On one machine however the dialog prompts to open or save the excel document
(e.g. myexcel.xls) but when I click save, the filename textbox contains the
name of the page (mypage.aspx) instead of the excel document. When I save
now the document, not the excel document but really the page's html is saved
on disk.

All machines are set up with

Windows 2000 SP2
Excel 9.0.3821 SR-1 (Excel 2000)
Internet Explorer 6.0.2800.1106CO

Can somebody help?

Kind regards,
Michael

Alper OZGUR · Feb 15, 2006

What is the other machines excel version?

Michael Groeger · Feb 15, 2006

They are all the same as stated below.

Alper OZGUR said:
What is the other machines excel version?

Alper OZGUR · Feb 15, 2006

I had the same problem and changed the code as belows. This had solved my
problem...

I hope it helps...

Response.Clear()

Response.Charset = ""

Response.ContentType = "application/vnd.ms-excel"

Dim stringWrite As New System.IO.StringWriter

Dim htmlWrite As New System.Web.UI.HtmlTextWriter(stringWrite)

Dim dg As New DataGrid

dg.DataSource = dsExp.Tables(0) ' dsExp is the dataset

dg.DataBind()

dg.GridLines = GridLines.Both

dg.HeaderStyle.Font.Bold = True

dg.DataBind()

Dim Img As New System.Web.UI.WebControls.Image

Img.ImageUrl = "images/reportlogo.jpg"

Img.RenderControl(htmlWrite)

dg.RenderControl(htmlWrite)

Response.Write("<html><head><META HTTP-EQUIV=""Content-Type""
CONTENT=""text/html; charset=utf-8""></head><body>" & stringWrite.ToString &
"</html></body>")

Response.End()

Guest · Feb 15, 2006

I suspect you're missing one of these key lines of code:
Response.Clear()

Response.ContentType = "application/ms-excel"

Response.AddHeader("Content-Disposition", _
"inline;filename=test.xls")

I've outlined all the necessary steps to do a proper Excel export here:
http://SteveOrr.net/articles/ExcelExport.aspx

Michael Groeger · Feb 16, 2006

Hi Steve,

the excel generation and the transfer to the client is done by a third party
tool (Aspose.Excel). I think the content - type is set to ms-excel, but i am
not quite sure. As the problem happens only on one machine I think it has
something to do with machine settings rather than with coding.

Regards,
Michael

Michael Groeger · Feb 16, 2006

That's all done by a third party tool (Aspose.Excel) so I can't do that.

I want to have a button in a web page with action for open new phone contact page and fill it with some date	1	Aug 31, 2023
Excel .CSV problem with save	3	Nov 13, 2007
How can I view / open / render / display a pdf file with c code?	0	Sep 23, 2023
SaveAs excel Dialog and IIS ConnectionTimeOut	2	Apr 20, 2010
save as dialog	3	Jan 19, 2007
On Clicking on Open button in asp download dialog it open two copy ofexcell file??	0	Nov 17, 2008
problem with FileStream and excel	7	Jul 15, 2009
Do you want to save or open this file?	4	Nov 24, 2009

Problem with Open Save dialog and excel

Michael Groeger

Alper OZGUR

Michael Groeger

Alper OZGUR

Guest

Michael Groeger

Michael Groeger

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads