Home All Groups Group Topic Archive Search About

Insert Excel Header from ASP



Author
13 Dec 2005 11:37 PM
creed1
I am currently working with an Active Server Page (ASP) that is set to
redirect its output to Excel using Response.ContentType =
"application/vnd.ms-excel".  It works great, but I need to find a way to
insert a header and/or footer into the resulting worksheet.  Does Excel
recognize any meta tags or CSS attributes that can be used to insert a header
or footer?

Author
14 Dec 2005 3:50 AM
Mark J. McGinty
"creed1" <cre***@discussions.microsoft.com> wrote in message
news:A2CF51F3-5E42-4AF7-830E-4FE69ED0671D@microsoft.com...
>I am currently working with an Active Server Page (ASP) that is set to
> redirect its output to Excel using Response.ContentType =
> "application/vnd.ms-excel".  It works great, but I need to find a way to
> insert a header and/or footer into the resulting worksheet.  Does Excel
> recognize any meta tags or CSS attributes that can be used to insert a
> header
> or footer?

What do you mean by 'header' and 'footer'?  And what is the format of your
output?

Excel will accept HTML tables, and it will even respect some (but not all)
CSS; for instance, it respects styles text-align and color, but not width.


-Mark
Author
15 Dec 2005 1:13 AM
creed1
By header and footer, I mean the header and footer that you can access from
the File, Page Setup menu in Excel.

Show quote
"Mark J. McGinty" wrote:

>
> "creed1" <cre***@discussions.microsoft.com> wrote in message
> news:A2CF51F3-5E42-4AF7-830E-4FE69ED0671D@microsoft.com...
> >I am currently working with an Active Server Page (ASP) that is set to
> > redirect its output to Excel using Response.ContentType =
> > "application/vnd.ms-excel".  It works great, but I need to find a way to
> > insert a header and/or footer into the resulting worksheet.  Does Excel
> > recognize any meta tags or CSS attributes that can be used to insert a
> > header
> > or footer?
>
> What do you mean by 'header' and 'footer'?  And what is the format of your
> output?
>
> Excel will accept HTML tables, and it will even respect some (but not all)
> CSS; for instance, it respects styles text-align and color, but not width.
>
>
> -Mark
>
>
>

AddThis Social Bookmark Button