I am trying to use the tagsets.excelXP with the style set to minimal to output a report to an excel file. If there are numeric missing values, excel won't open the file created. If I use a different style, such as SASDocPrinter, excel opens the file with no problems. I searched the SAS website but I didn't see anything about this.
Has anyone else had this problem? I am using the most current (June 2006) tagset definition and I am using SAS 9.1.3 service pack 3 on a WinXP machine. I've included a small program that recreates my problem.
input a b c;
1 2 3
3 . 2
0 0 3
I'm not sure the problem is with your data. I tested an October (working/not final) version of the ExcelXP tagset and I do not believe it had a problem with style=minimal.
In the meantime, however, if you look at this code (after you run it and use it), you should see something very similar to what you get with style=minimal and this style does work with the June tagset that's out on the ODS MARKUP web site.
** Modify the XLStatistical style to get rid of;
** all border lines, colors, etc;
define style styles.XLStatistical;
parent = styles.Statistical;
style Body from Body/
style table from Output /
style Header from Header /
style RowHeader from RowHeader /
style Data from Data /
ods tagsets.excelxp file='c:\temp\use_style.xls'
If you need an updated copy of the ExcelXP tagset so you can use style=minimal, you will have to contact Tech Support.