Hi all,
I found a solution to my problem..thought I'd share
Add a pair of <style tags 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...
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