469,963 Members | 1,701 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,963 developers. It's quick & easy.

ASP -> Excel

Hello all.. I'm working on some reports, and have added the ability to
"download" the reports to excel. Not a big deal, fairly straight forward.
However, PHB wants to be able to create some pivot tables from said reports
(again.. no biggie) and when he goes to save the file, Excel wants to save
the file as a web page instead of and Excel spreadsheet.

Now.. I know the simple thing here is to just pick Excel from the drop down
box in the save as dialog.. but.. PHB would "prefer" to not have to do that.

Has anyone been able to jump this hurdle before? My good friend google
hasn't turned anything up. My preference is to give PHB the middle finger..
but alas.. the paycheck is keeping me from doing that.

Thanks!
Jul 22 '05 #1
2 1653
Are you sure that this isn't just a setting in Excel for that person? Like:
Tools--Options--Transition--Save Excel files as:

Also, how are you returning the Excel file from your server? With a
response.contenttype="application/vnd.ms-excel"?

Ray at work

"Bryan Harrington" <ne**@whydoyouneedtosendspam.not> wrote in message
news:e0**************@TK2MSFTNGP09.phx.gbl...
Hello all.. I'm working on some reports, and have added the ability to
"download" the reports to excel. Not a big deal, fairly straight forward.
However, PHB wants to be able to create some pivot tables from said reports (again.. no biggie) and when he goes to save the file, Excel wants to save
the file as a web page instead of and Excel spreadsheet.

Now.. I know the simple thing here is to just pick Excel from the drop down box in the save as dialog.. but.. PHB would "prefer" to not have to do that.
Has anyone been able to jump this hurdle before? My good friend google
hasn't turned anything up. My preference is to give PHB the middle finger.. but alas.. the paycheck is keeping me from doing that.

Thanks!

Jul 22 '05 #2
Thanks for your response Ray.. Yes.. I'm adding the response.contenttype to
the header.. all that works great.

And no, it's not a setting in Excel as far as I can tell.. When I return
the excel file from ASP and save it, I can open it in notepad, and it's a
bunch of <td>data</td>'s... if I do a save as over to excel, then when you
open it in notepad you get to see all the fun ascii stuff.

PHB doesn't want to have to make that "extra" click to the drop down box to
specify save as excel. I don't think it can be done, but there are lots and
lots of smart people out there working for lots and lots of PHB's.
"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:ux**************@tk2msftngp13.phx.gbl...
Are you sure that this isn't just a setting in Excel for that person? Like: Tools--Options--Transition--Save Excel files as:

Also, how are you returning the Excel file from your server? With a
response.contenttype="application/vnd.ms-excel"?

Ray at work

"Bryan Harrington" <ne**@whydoyouneedtosendspam.not> wrote in message
news:e0**************@TK2MSFTNGP09.phx.gbl...
Hello all.. I'm working on some reports, and have added the ability to
"download" the reports to excel. Not a big deal, fairly straight forward. However, PHB wants to be able to create some pivot tables from said

reports
(again.. no biggie) and when he goes to save the file, Excel wants to save the file as a web page instead of and Excel spreadsheet.

Now.. I know the simple thing here is to just pick Excel from the drop

down
box in the save as dialog.. but.. PHB would "prefer" to not have to do

that.

Has anyone been able to jump this hurdle before? My good friend google
hasn't turned anything up. My preference is to give PHB the middle

finger..
but alas.. the paycheck is keeping me from doing that.

Thanks!


Jul 22 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Bryan Harrington | last post: by
2 posts views Thread by ExDelphi | last post: by
3 posts views Thread by Gerry Blais | last post: by
10 posts views Thread by Mark Day | last post: by
2 posts views Thread by Japi | last post: by
1 post views Thread by setterst | last post: by
3 posts views Thread by kenduron | last post: by
reply views Thread by =?Utf-8?B?c3Bhcmtlcg==?= | last post: by
1 post views Thread by rainxy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.