SAS ODS HTML page breaks for Excel

Expand Post »

I am not sure if it is possible, but I am creating a SAS report using ODS HTML and I am saving it as a .xls so it is opened with Microsoft Excel. I am wondering if it is possible to program in the page breaks, so that I can control what tables show up on what pages and to prevent parts of tables being orphaned from the rest of the table. Any help would be greatly appreciated.

Thanks,
Nick

Similar Threads

How to set html page size attributes in HTML and CSS
Calling function to add HTML to the page in ASP.NET
Can I use a template html page within another html page in Site Layout and Usability
How To Hyperlink Normal HTML page with ASP.NET Page? in ASP.NET
PHP in a html page? in PHP

stupidenator

Reputation Points: 18

Solved Threads: 4

Junior Poster

Offline

192 posts
since Mar 2005

Permalink

Feb 9th, 2009

Re: SAS ODS HTML page breaks for Excel

Hi there,

I was trying to do the same with HTML for Excel, and so far the only option I see is to insert RowBreak XML tags into HTML header where Excel-related settings are kept when generating the report. Excel does not understand CSS attributes such as page-break-after, page-break-before or page-break-inside. Also on W3C website it is said to avoid using these attributes inside tables, what in Excel is the main container element usually.

My initial testing went with Excel 2003.Today tried to test with 2007 version and it is still the same, CSS page-breaks are not understood and this is probably because the file is named with *.xls extension and maybe Excel 2007 tries to render HTML/XLS document with Excel 2003 engine.

Anyway, if you find out anything usefull, please tell me, because I don't want to leave page-break adjusting to user, everything has to be automatic. Thanks.

Last edited by Romasio; Feb 9th, 2009 at 2:58 am.

Romasio

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

2 posts
since Oct 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Computer Science Forum Timeline: Stanford Online!->Course | Programming Methodology

Next Thread in Computer Science Forum Timeline: Working of Lexical analyzer

DaniWeb Message

Cancel Changes

User Name
Password