...

View Full Version : CSS and Excel page settings



florida
04-24-2006, 01:39 PM
I am outputting an Excel 2003 spreadsheet from my Database driven site.

It works great where I am using CSS to set the Excel Header and Landscape printing:



@page
{
mso-header-data:"The Header title Here";
mso-footer-data:"The Footer part Here";
margin:.3in .3in .3in .3in;
mso-header-margin:.18in;
mso-footer-margin:.20in;
mso-page-orientation:landscape;
}


Can CSS set the Column Titles so they appear on every printed page?

Currently it only prints Column Titles on the first page and not the remaining pages.
So I have to manually set it in Excel going into Page Setup and putting in "Rows to Repeat at top" for my Print title.

Please advise.

Arbitrator
04-24-2006, 02:05 PM
Would be hard to say since that appears to be CSS proprietary to the Microsoft program you're using. Using normal CSS I don't think this is possible though. In theory, I believe that <thead> and <th> content is supposed to appear at the top of every page where the table appears when printed but I haven't actually seen it work (didn't work last time I checked anyway).



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum