Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Jul 2002
    Posts
    362
    Thanks
    0
    Thanked 0 Times in 0 Posts

    CSS and Excel page settings

    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:

    Code:
    @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.

  • #2
    Senior Coder Arbitrator's Avatar
    Join Date
    Mar 2006
    Location
    Splendora, Texas, United States of America
    Posts
    3,387
    Thanks
    32
    Thanked 288 Times in 282 Posts
    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).
    For every complex problem, there is an answer that is clear, simple, and wrong.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •