Exporting as Excel (database results)

[Jawahar Rajan]

All,
I am trying to export a result set as an excel spread
sheet. Most of the time this works as expected, when a
user chooses to save as excel the browser pop-up a save as
dialog to allow the user to save the spreadshet with
a .xls name.

Some times the browser will open up the file as text file
within the bvrowser itself?

These are my two lines of code to prompt the save as
dialog for a Browser:
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-
disposition", "attachment;filename=ReportsName.xls"

I do not use any HTML to write out the Response from the
Database rather just plain text and VBTab for a new column
and VBCrLf for a new line.

Thanks
Jawahar

 

[Ray at]

If the user does not have Excel or if the user has "confirm open after
download" selected for the .xls filetype, he will get the download prompt.

Ray at work

 

[Bullschmidt]

Would possibly removing the word attachment; help at all?


Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...