J
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
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