471,595 Members | 1,471 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,595 software developers and data experts.

Add Header/Footer to excel report from ASP..

Hi all,

I'm trying to generate an excel report from an ASP web page using ..

"response.ContentType = "application/vnd.ms-excel" ....

I need to add a custom header & footer to the excel report on
generation. Is there a way to do this from the web without installing
Excel on the webserver? ..

Any help is appreciated...thanks
mj

Aug 1 '06 #1
4 4396
Hi: I have 100's of records in my inbox which i saved into a text file.
I need help how to i import them into access table through ASP.

Thanks,

Eric

Aug 2 '06 #2
Hi: I have 100's of records in my inbox which i saved into a text file.
I need help how to i import them into access table through ASP.

Thanks,

Eric

Aug 2 '06 #3
Hi: I have 100's of records in my inbox which i saved into a text file.
I need help how to i import them into access table through ASP.

Thanks,

Eric

Aug 2 '06 #4
Hi all,

I found a solution to my problem..thought I'd share

Add a pair of <styletags to the asp code with the following (eg.)

<style>
<!--headfoot
{mso-displayed-decimal-separator:"\.";
mso-displayed-thousand-separator:"\,";}
@page
{mso-header-data:"&LHeaderText";
mso-footer-data:"Page &P of &N";
margin:1.0in .75in 1.0in .75in;
mso-header-margin:.5in;
mso-footer-margin:.5in;} -->
</style>

This sets the Header/Footer for the excel report generated...

jm******@gmail.com wrote:
Hi all,

I'm trying to generate an excel report from an ASP web page using ..

"response.ContentType = "application/vnd.ms-excel" ....

I need to add a custom header & footer to the excel report on
generation. Is there a way to do this from the web without installing
Excel on the webserver? ..

Any help is appreciated...thanks
mj
Aug 2 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Pea | last post: by
4 posts views Thread by John hoffman | last post: by
reply views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.