By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,854 Members | 2,015 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,854 IT Pros & Developers. It's quick & easy.

Problem with Open Save dialog and excel

P: n/a
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
Feb 15 '06 #1
Share this Question
Share on Google+
6 Replies


P: n/a
What is the other machines excel version?

"Michael Groeger" <go*********@web.de>, haber iletisinde şunları
yazdı:un**************@tk2msftngp13.phx.gbl...
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

Feb 15 '06 #2

P: n/a
They are all the same as stated below.

"Alper OZGUR" <al******@gmail.com> schrieb im Newsbeitrag
news:OF**************@TK2MSFTNGP10.phx.gbl...
What is the other machines excel version?

"Michael Groeger" <go*********@web.de>, haber iletisinde şunları
yazdı:un**************@tk2msftngp13.phx.gbl...
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


Feb 15 '06 #3

P: n/a
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" <go*********@web.de>, haber iletisinde şunları
yazdı:uT*************@TK2MSFTNGP11.phx.gbl...
They are all the same as stated below.

"Alper OZGUR" <al******@gmail.com> schrieb im Newsbeitrag
news:OF**************@TK2MSFTNGP10.phx.gbl...
What is the other machines excel version?

"Michael Groeger" <go*********@web.de>, haber iletisinde şunları
yazdı:un**************@tk2msftngp13.phx.gbl...
> 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
>
>



Feb 15 '06 #4

P: n/a
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

--
I hope this helps,
Steve C. Orr
MCSD, MVP
http://SteveOrr.net

"Michael Groeger" wrote:
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

Feb 15 '06 #5

P: n/a
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

"Steve C. Orr" <St***@Orr.net> schrieb im Newsbeitrag
news:84**********************************@microsof t.com...
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

--
I hope this helps,
Steve C. Orr
MCSD, MVP
http://SteveOrr.net

"Michael Groeger" wrote:
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

Feb 16 '06 #6

P: n/a
That's all done by a third party tool (Aspose.Excel) so I can't do that.
"Alper OZGUR" <al******@gmail.com> schrieb im Newsbeitrag
news:ew**************@TK2MSFTNGP15.phx.gbl...
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" <go*********@web.de>, haber iletisinde şunları
yazdı:uT*************@TK2MSFTNGP11.phx.gbl...
They are all the same as stated below.

"Alper OZGUR" <al******@gmail.com> schrieb im Newsbeitrag
news:OF**************@TK2MSFTNGP10.phx.gbl...
What is the other machines excel version?

"Michael Groeger" <go*********@web.de>, haber iletisinde şunları
yazdı:un**************@tk2msftngp13.phx.gbl...
> 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
>
>



Feb 16 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.