I have a report that goes into excel with tagsets.exelxp, with that report I have a title that contain a name and a date. The first part should be aligned to the left and the date align to the right. It works fine in ods html, but in excel it writes the first part on one line and the second part is written on the next row. Is it possible to get this title on the same row?
For TAGSETS.EXCELXP, the HTML methods do not work. However, TAGSETS.EXCELXP has PRINT Header and PRINT Footer sub-options with examples of how to make them work. To see the sub-options...
ods tagsets.excelxp file='xxx.xml' style=sasweb
.... ... more code;
ods tagsets.excelxp close;
Then look in the SAS log for the print header related options.