Tagsets.ExcelXP - Custom Page Break

[wcp_fnfg]

I am looking for a way to tell excel "put a page break at this row" using an output with excelxp and proc report.

Thanks!

[Cynthia_sas]

Hi:

  As far as I know, there is no way for SAS or ODS to operate the menu choices that are on the Excel ribbon, such as highlighting a row and then selecting Page Layout --> Breaks --> Insert Page Break. You can influence printing to some extent with the suboptions for FitToPage and/or Pages_FitWidth or Pages_FitHeight, but that is not the same as setting the Print Area or inserting Page Breaks using Excel menu options. To reveal the suboptions available to use in your version of TAGSETS.EXCELXP, add the doc='HELP' suboption to your invocation:

ods tagsets.excelxp file='c:\temp\showcars.xml'

    options(doc='Help') style=sasweb;

Also, this paper talks in a lot of detail about suboptions and how to use them (http://www.nesug.org/proceedings/nesug08/ap/ap06.pdf), look at page 5, for example.

cynthia