|
it
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Insert Excel Header from ASP
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? "creed1" <cre***@discussions.microsoft.com> wrote in message What do you mean by 'header' and 'footer'? And what is the format of your 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? 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 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 > > > |
|||||||||||||||||||||||