Hi:
Some comments:
You are NOT creating an XLS file. You are creating an HTML file that Excel knows how to open and render. Each of those files conforms to an HTML specification and Excel renders each of those files DIFFERENTLY, depending on the specification that you see at the top of each file.
So, let's remove your style template from the equation, right now. In the long run, your style template will NOT do what you want to do. Let's look at this code sample:
[pre]
ods tagsets.MSOffice2K file='mso.html' style=sasweb;
ods html3 file='ht3.html' style=sasweb;
ods html file='ht4.html' style=sasweb;
title1 'test1';
title2 'test2';
proc print data=sashelp.class (obs=3);
run;
ods _all_ close;
[/pre]
Notice that I have given the files their correct file extension of HTML. Excel will still open the files: you will either have to find the files in Windows Explorer and Right-mouse click and open with Excel, or you will have to launch Excel and navigate to where the 3 files live and then open each of them.
The fact that DIFFERENT HTML tags get written for each destination is no accident. If you opened each of the above files with Notepad, you would see the following tags at the top of each file:
[pre]
MSO.HTML (note that MSOFFICE2K is NOT creating HTML 4.01 compliant HTML tags -- the output file has no DOCTYPE at the top of the file and conforms to the Microsoft spec, not the W3C spec for HTML -- this is OK, as long as you KNOW you want to conform to the Microsoft spec.).
<html xmlns:v="urn:schemas-microsoft-com:vml">
HT3.HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
HT4.HTML
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
[/pre]
ODS -knows- which type of HTML tags should be generated for each destination. For example, it is OK in HTML 3.2 to have embedded font and color information. That is NOT recommended by the W3C for HTML 4 files. If you want HTML 4 to act like HTML3, the easiest thing to do is just use the HTML3 destination.
Let's look further down in each of the files, now, at the ENTIRE HTML that is written for those 2 title statements:
[pre]
MSO.HTML (NOT in a TABLE tag)
<h1 class="SystemTitle" style=" text-align: center;">test1</h1>
<h1 class="SystemTitle2" style=" text-align: center;">test2</h1>
HT3.HTML (Titles ARE in a TABLE tag)
<TABLE cellspacing=1 cellpadding=1 rules=NONE frame=VOID border=0 width=100% bgcolor="#FFFFFF">
<TR>
<TD ALIGN=CENTER bgcolor="#FFFFFF"><font face="Arial, Helvetica, sans-serif" size="4" color="#003399"><b>test1</b></font></TD>
</TR>
<TR>
<TD ALIGN=CENTER bgcolor="#FFFFFF"><font face="Arial, Helvetica, sans-serif" size="4" color="#003399"><b>test2</b></font></TD>
</TR>
</TABLE>
HT4.HTML (Titles ARE in a TABLE tag)
<table class="SysTitleAndFooterContainer" width="100%" cellspacing="1" cellpadding="1" rules="none" frame="void"
border="0" summary="Page Layout">
<tr><td class="c SystemTitle">test1</td></tr>
<tr><td class="c SystemTitle2">test2</td></tr>
</table>
[/pre]
You can see that it is NOT just the H1 tag, it is the fact that for HTML3 and HTML4 files, the SAS titles are put inside a TABLE tag. For the MSOFFICE2K file, the SAS titles are put into <H1> tags. I can only assume this is done because it conforms to the Microsoft specification. I don't even KNOW whether Microsoft Excel would correctly render the <H1> tags if you put them inside a TABLE tag.
In order to change the type or kind of markup language that gets written out, you would change the tagset template, not the style template. If you ONLY wanted to change the underlying fonts and colors, then the issue would be to change the style template. If you like the way that the HTML 3 output looks when rendered in Excel, partly that happens because Excel "likes" the HTML3 tags and "likes" the TABLE tag around the SAS titles.
cynthia
