Tagsets.ExcelXP - Custom Page Break

wcp_fnfg — Fri, 28 Mar 2014 15:04:08 GMT

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!

Re: Tagsets.ExcelXP - Custom Page Break

Cynthia_sas — Fri, 28 Mar 2014 16:27:01 GMT

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

topic Tagsets.ExcelXP - Custom Page Break in ODS and Base Reporting

Tagsets.ExcelXP - Custom Page Break

Re: Tagsets.ExcelXP - Custom Page Break