467,161 Members | 974 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

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

export to excel

I'm not sure if this is the best place for this post or not, but I can't
find many asp newsgroups anymore.

I have an app that's 3-4 years old, and has been working just fine. One of
the pages exports the html to Excel. My users just upgraded from
Office97/2000 to Office XP/2003, and now the export to Excel isn't working
for them.

This is the code that I use, and from what I find around the Internet, it's
all I need. Does anyone have any suggestions for what might be causing this
to not work in Office XP/2003? It still works just fine on Office 2000.
Could it be a security setting in the newer version of Office?

Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
EnableViewState = false

Thanks, Andre
Jul 19 '05 #1
  • viewed: 4390
Share:
4 Replies
What is "not working for them" mean? Do they get a file prompt at least? I
have several reports in the similar way, but I haven't seen any difference
upgrading to Office 2003.

--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com
"Andre" <no@spam.com> wrote in message
news:ez****************@TK2MSFTNGP14.phx.gbl...
I'm not sure if this is the best place for this post or not, but I can't
find many asp newsgroups anymore.

I have an app that's 3-4 years old, and has been working just fine. One of the pages exports the html to Excel. My users just upgraded from
Office97/2000 to Office XP/2003, and now the export to Excel isn't working
for them.

This is the code that I use, and from what I find around the Internet, it's all I need. Does anyone have any suggestions for what might be causing this to not work in Office XP/2003? It still works just fine on Office 2000.
Could it be a security setting in the newer version of Office?

Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
EnableViewState = false

Thanks, Andre

Jul 19 '05 #2
They get 1 of 2 different dialog boxes.

- One says "Microsoft Office Excel cannot access the file 'my url here...'.
There are several possible reasons:
- The file name or path does not exist.
- The file is being used by another program.
- The workbook you are trying to save has the same name as a currently
open workbook.

- The other says "IE cannot download excel_report.asp from 'my url...'. IE
was not able to open the Internet site. The requested site is either
unavailable or cannot be found. Please try again later.

Does this tell you anything?

Andre
"Manohar Kamath" <mk*****@TAKETHISOUTkamath.com> wrote in message
news:%2****************@TK2MSFTNGP15.phx.gbl...
What is "not working for them" mean? Do they get a file prompt at least? I
have several reports in the similar way, but I haven't seen any difference
upgrading to Office 2003.

--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com
"Andre" <no@spam.com> wrote in message
news:ez****************@TK2MSFTNGP14.phx.gbl...
I'm not sure if this is the best place for this post or not, but I can't
find many asp newsgroups anymore.

I have an app that's 3-4 years old, and has been working just fine. One

of
the pages exports the html to Excel. My users just upgraded from
Office97/2000 to Office XP/2003, and now the export to Excel isn't working for them.

This is the code that I use, and from what I find around the Internet,

it's
all I need. Does anyone have any suggestions for what might be causing

this
to not work in Office XP/2003? It still works just fine on Office 2000.
Could it be a security setting in the newer version of Office?

Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
EnableViewState = false

Thanks, Andre


Jul 19 '05 #3
see if this helps:
http://groups.google.com/groups?hl=e...TNGP11.phx.gbl

--
Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com
"Andre" <no@spam.com> wrote in message
news:%2******************@TK2MSFTNGP11.phx.gbl...
They get 1 of 2 different dialog boxes.

- One says "Microsoft Office Excel cannot access the file 'my url here...'. There are several possible reasons:
- The file name or path does not exist.
- The file is being used by another program.
- The workbook you are trying to save has the same name as a currently
open workbook.

- The other says "IE cannot download excel_report.asp from 'my url...'. IE was not able to open the Internet site. The requested site is either
unavailable or cannot be found. Please try again later.

Does this tell you anything?

Andre
"Manohar Kamath" <mk*****@TAKETHISOUTkamath.com> wrote in message
news:%2****************@TK2MSFTNGP15.phx.gbl...
What is "not working for them" mean? Do they get a file prompt at least? I
have several reports in the similar way, but I haven't seen any difference upgrading to Office 2003.

--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com
"Andre" <no@spam.com> wrote in message
news:ez****************@TK2MSFTNGP14.phx.gbl...
I'm not sure if this is the best place for this post or not, but I can't find many asp newsgroups anymore.

I have an app that's 3-4 years old, and has been working just fine. One
of
the pages exports the html to Excel. My users just upgraded from
Office97/2000 to Office XP/2003, and now the export to Excel isn't working for them.

This is the code that I use, and from what I find around the Internet,

it's
all I need. Does anyone have any suggestions for what might be

causing this
to not work in Office XP/2003? It still works just fine on Office

2000. Could it be a security setting in the newer version of Office?

Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
EnableViewState = false

Thanks, Andre



Jul 19 '05 #4
Unfortunately, it didn't. I removed the "cache" instances from the code and
the export still works great for me on Office 2k. My user on XP still isn't
able to get it to work. She's also telling me that if she exports just a
few thousand records, it will work. But the one we're working on now is 12k
records. Like I said, it works great still on a desktop with Office 2k.

Any other suggestions are much appreciated.

Thanks, Andre
"Mark Schupp" <ms*****@ielearning.com> wrote in message
news:eP**************@TK2MSFTNGP11.phx.gbl...
see if this helps:
http://groups.google.com/groups?hl=e...TNGP11.phx.gbl
--
Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com
"Andre" <no@spam.com> wrote in message
news:%2******************@TK2MSFTNGP11.phx.gbl...
They get 1 of 2 different dialog boxes.

- One says "Microsoft Office Excel cannot access the file 'my url here...'.
There are several possible reasons:
- The file name or path does not exist.
- The file is being used by another program.
- The workbook you are trying to save has the same name as a currently
open workbook.

- The other says "IE cannot download excel_report.asp from 'my url...'.

IE
was not able to open the Internet site. The requested site is either
unavailable or cannot be found. Please try again later.

Does this tell you anything?

Andre
"Manohar Kamath" <mk*****@TAKETHISOUTkamath.com> wrote in message
news:%2****************@TK2MSFTNGP15.phx.gbl...
What is "not working for them" mean? Do they get a file prompt at least? I have several reports in the similar way, but I haven't seen any difference upgrading to Office 2003.

--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com
"Andre" <no@spam.com> wrote in message
news:ez****************@TK2MSFTNGP14.phx.gbl...
> I'm not sure if this is the best place for this post or not, but I can't > find many asp newsgroups anymore.
>
> I have an app that's 3-4 years old, and has been working just fine. One of
> the pages exports the html to Excel. My users just upgraded from
> Office97/2000 to Office XP/2003, and now the export to Excel isn't

working
> for them.
>
> This is the code that I use, and from what I find around the
Internet, it's
> all I need. Does anyone have any suggestions for what might be

causing this
> to not work in Office XP/2003? It still works just fine on Office 2000. > Could it be a security setting in the newer version of Office?
>
> Response.Buffer = True
> Response.ContentType = "application/vnd.ms-excel"
> Response.Charset = ""
> EnableViewState = false
>
> Thanks, Andre
>
>



Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Matt | last post: by
6 posts views Thread by Elena | last post: by
13 posts views Thread by Hemant Sipahimalani | last post: by
5 posts views Thread by Simon | last post: by
1 post views Thread by smaczylo@gmail.com | last post: by
3 posts views Thread by =?Utf-8?B?YzY3NjIyOA==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.