 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / ASP.NET / General / February 2006Problem with Open Save dialog and excel
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 What is the other machines excel version? "Michael Groeger" <google.news@web.de>, haber iletisinde þunlarý yazdý:unTGUSjMGHA.3432@tk2msftngp13.phx.gbl... > Hi, > [quoted text clipped - 24 lines] > Kind regards, > Michael They are all the same as stated below. > What is the other machines excel version? > [quoted text clipped - 28 lines] > > Kind regards, > > Michael 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() "Michael Groeger" <google.news@web.de>, haber iletisinde þunlarý yazdý:uTwcZtjMGHA.344@TK2MSFTNGP11.phx.gbl... > They are all the same as stated below. > [quoted text clipped - 35 lines] >> > Kind regards, >> > Michael That's all done by a third party tool (Aspose.Excel) so I can't do that. > I had the same problem and changed the code as belows. This had solved my > problem... [quoted text clipped - 78 lines] > >> > Kind regards, > >> > Michael 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  SignatureI hope this helps, Steve C. Orr MCSD, MVP http://SteveOrr.net > Hi, > [quoted text clipped - 20 lines] > Kind regards, > Michael 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 > I suspect you're missing one of these key lines of code: > Response.Clear() [quoted text clipped - 37 lines] > > Kind regards, > > Michael Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.