Fit to page width in ODS TAGSETS.EXCELXP

[Olivier]

Hi all.
Something weird does happen when I use the ExcelXp tagset to display large tables. In fact, the weird thing is that it does not happen to behave like expected.
Il want to use the FIT_PAGEWIDTH option to resize automatically the output when printing, on a single page. The "printer setup" is correctly defined in Excel, but the radio button is not set, so any settings on page width or height are just ignored.
Am I wrong somewhere, or is there something missing there ?
Sample below :[pre]
DATA work.large ;
ARRAY columns (15) ;
DO i = 1 TO 100 ;
DO j= 1 TO DIM(columns) ;
columns(j)=RANNOR(0) ;
END ;
OUTPUT ;
END ;
RUN ;
ODS TAGSETS.EXCELXP FILE="c:\temp\large.xls" OPTIONS(PAGES_FITWIDTH="2") ;
PROC PRINT ;
RUN ;
ODS TAGSETS.EXCELXP CLOSE ;
[/pre]
Thanks in advance for any hint, help or suggestion.
olivier

[Cynthia_sas]

Hi, Olivier:
I have never experimented with PAGES_FITWIDTH, but if you open a track with Tech Support, and this is a reproducible example; then the track will be handled by the folks who know how to fix the issue.

cynthia

[deleted_user]

Consider using the FitToPages option. As in:
[pre]
ODS TAGSETS.EXCELXP FILE="c:\temp\large.xls" OPTIONS(PAGES_FITWIDTH="2" FitToPages="YES") ;
[/pre]

------------------------------------------------------------------------------
The following web-page was helpful to me at the time of this post.
http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_help.html

Also using ...
[pre]
ODS TAGSETS.EXCELXP OPTIONS( doc="help" );ODS TAGSETS.EXCELXP close;
[/pre]
...will output useful help documentation to the log stream.

I really find TAGSETS.EXCELXP helpful. I'm thankful to those whom have worked on this.

[Eric_SAS]

Change your ods statement to this.

ODS TAGSETS.EXCELXP FILE="large.xls" OPTIONS(PAGES_FITWIDTH="2" FitToPage="YES") ;

It would be nice if the FitToPage option would turn on if a FitWidth or Height were given, I will add that in a future release of the tagset.