Hi everyone,

I am not sure if this belongs to this forum, but here goes:

I am using ASP.NET and Excel as a reporting engine. Based on user selection, I generate some HTML and stream it to the client machine by setting the MIME type to Excel. Everything works fine, I have my tabular data in Excel.

However, I want to format my excel document to have a header and footer. How can I do that using the above method?

Anyone who has any experience with something like this and can offer me some tips, I would be really grateful

Thanks,
Pankaj

If you are streaming HTML to the browser (which goes into Excel) you can create a header/footer just like you would if the HTML were going to show up in the browser as plain HTML. It's just that the header and footer will have to be part of the html table. You could create a single cell that spans all the columns and has a larger font size and that should work. Likewise for the footer.

Here's an example:
http://www.geekdork.com/samples/webToExcel.aspx
Click the "Show as plain HTML" link in the spreadsheet for the plain HTML view to see what I'm suggesting.

Peter
------------------------------------------------------
Work smarter, not harder.