SAS to Excel via XML: Text Wrapping

[Mazderati]

Hi All,

I'm looking to turn on text wrapping when outputting data to an Excel spreadsheet. As of right now, the spreadsheet does not wrap text within cells and, therefore, long comments are left hidden until you click on the respective cells.

I found this three year old thread (thread376-1178234) that addressed the same issue in post number two. Unfortunately, I can't get the modified code to work. Any suggestions for turning on text wrapping when using ODS, XML, and the ExcelXP tagset?

Thanks in advance.

Kyle

 

[ChrisW75]

Have you tried the help file that comes with the tagset? Those changes I specified were for an earlier version of the tagset, and there seems to be some conflict with the newer version.
To access the helpfile do this:-

ods tagsets.excelxp file='test.xml' data='test.ini' options(doc='Help');
ods tagsets.excelxp close;

That will list all the options. I think there's an option there for specifying wrap text which may have been fixed in this new version...
Let me know if it doesn't work and I'll dump out the full tagset I'm currently using, and that should allow you to do it - but please note, I've been having problems with this tagset since the new version went in, and now I have to submit it fresh each time or it won't work. I've worked around it by %INCLUDE-ing the tagset code at the start of each program.

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.