This worked for me in SAS 9.2 with the latest ExcelXP tagset:
ods tagsets.excelxp file="C:\temp\xpreportzz.xls" style=minimal
options(Doc='Help' embedded_titles='yes' sheet_name='Report1');
title f='Arial' h=14pt 'Title1';
proc report data=sashelp.class nowd;
By default, titles are put into the Header area of the Workbook/Worksheet. So you never see your SAS title unless you are in Print Preview mode. However, the embedded_titles suboption allows you to embed your titles into the spreadsheet. The sheet_name suboption allows you to name each sheet. You do not need to respecify style=minimal between sheets.
I also used the DOC='Help' suboption -- it is the self-documenting help file that displays all the ExcelXP suboptions in the SAS Log -- very helpful.
I used the H= attribute in the title statements to make sure that my fonts and sizes were getting set (and they are). I am also in the habit of quoting fonts and using the -exact- name. On my system, the fonts are Calibri and Arial so those are the names I used in quotes.
Also, ODS NOPTITLE stays in effect until you start a new session or turn PTITLE back on. So you only need to issue that statement once. And, I assume that this syntax snippet from your post was just a typo -- you have too many = and too many " and/or a missing semicolon:
ods html file="="C:\report1.xls" style=minimal; <--extra " extra =
ODS tagsets.excelxp file = ="C:\report.xls" <-- no semi, 2 =
Probably -not- the SAS version, but the ExcelXP version. You can update the tagset template used by ODS. The version that was delivered with SAS 9.1.3 did not do embedded_titles, if I remember correctly. I think that was an added enhancement. You can look in your SAS log to see which tagset template is being used.
This is the tagset version that I was using: [pre]
NOTE: This is the Excel XP tagset (Compatible with SAS 9.1.3 and above, v1.94, 09/09/12) [/pre]
I am using SAS 9.2 Phase 2 and v1.94 is the tagset template that's included with that release of SAS. I figure v1.94 will be available on the download web site when it's deemed OK for SAS 9.1.3. My guess (and it's only a guess) is that there -might- be testing involved before the tagset is posted to make sure that it does work with SAS 9.1.3.