my little SAS drama runs as follows.
I wand to export a SAS-table into Excel. The format of the data in the worksheet has to meet several simple conditions:
1) Font Tahoma, 10pt;
2) All columns of width 10, save for the 2ns column, which must be of width 20;
3) The header background has to be orange
4) Wraptext=false, so that text larger than the cell is hidden and the row height remains constant.
Well, having invested several hours in ODS ExcelXP I came up with a rather miserable code, which nevertheless suits my purposes 1)-3). But I fail to handle wraptext in the heading, it is being set to true. And unless all the formatting criteria are implemented my prior painful efforts are in vain...