|
 |
asp_web_howto thread: Changing MIME types to Excel
Message #1 by "Edgar Reyes" <ereyes@t...> on Tue, 12 Mar 2002 16:59:20
|
|
Hello
I have an asp page that displays some data in a table but now I want to
display the same fields but in an excel sheet, I know that I can change
the MIME type right from ASP but now sure how its done, do I just add
<%
Response.Buffer = TRUE
Response.ContentType = "application/vnd.ms-excel"
%>
and it will take the data and display it in an excel sheet or is there
something else that I need to specified?
any help would be appreciated.
Message #2 by "Ken Schaefer" <ken@a...> on Wed, 13 Mar 2002 12:38:54 +1100
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Edgar Reyes" <ereyes@t...>
Subject: [asp_web_howto] Changing MIME types to Excel
: I have an asp page that displays some data in a table but now I want to
: display the same fields but in an excel sheet, I know that I can change
: the MIME type right from ASP but now sure how its done, do I just add
:
: <%
: Response.Buffer = TRUE
: Response.ContentType = "application/vnd.ms-excel"
: %>
:
: and it will take the data and display it in an excel sheet or is there
: something else that I need to specified?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Why don't you try it and see...
Cheers
Ken
Message #3 by "Drew, Ron" <RDrew@B...> on Wed, 13 Mar 2002 09:13:56 -0500
|
|
<% Response.ContentType =3D "application/vnd.ms-excel" %>
and then you use the response.write method , the data will be displayed
in
excel. It will prompt you whether to download the excel file or to open
it
from current location.
-----Original Message-----
From: Edgar Reyes [mailto:ereyes@t...]
Sent: Tuesday, March 12, 2002 11:59 AM
To: ASP Web HowTo
Subject: [asp_web_howto] Changing MIME types to Excel
Hello
I have an asp page that displays some data in a table but now I want to
display the same fields but in an excel sheet, I know that I can change
the MIME type right from ASP but now sure how its done, do I just add
<%
Response.Buffer =3D TRUE
Response.ContentType =3D "application/vnd.ms-excel"
%>
and it will take the data and display it in an excel sheet or is there
something else that I need to specified?
any help would be appreciated.
$subst('Email.Unsub').
Message #4 by Greg Griffiths <greg.griffiths@g...> on Wed, 13 Mar 2002 22:25:01 +0000
|
|
Or you can build a link to MS Excel on the client using ASP and VBScript
and then interact with Excel directly. Check out :
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=4&txtCodeId=6955
for a sample.
At 16:59 12/03/02 +0000, you wrote:
>Hello
>
>I have an asp page that displays some data in a table but now I want to
>display the same fields but in an excel sheet, I know that I can change
>the MIME type right from ASP but now sure how its done, do I just add
>
> <%
> Response.Buffer = TRUE
> Response.ContentType = "application/vnd.ms-excel"
>%>
>
>and it will take the data and display it in an excel sheet or is there
>something else that I need to specified?
>
>any help would be appreciated.
>
>
|
|
|
View Cart
