XL97: "Save As HTML" Does Not Create Some Tags (162027)

MORE INFORMATION

You can download the new Html.xla from the following Microsoft Web site: The Web authoring add-in, Internet Assistant Wizard (Html.xla), allows you to save a workbook in the HTML format. This add-in adds the "Save As HTML..." command to the File menu and allows you to convert the information in the active worksheet to an HTML text document.

If the "Save As HTML..." command is not available, load the Internet Assistant Wizard using the Add-in command on the Tools menu. When you run Setup, this add-in is installed as part of the Web Page Authoring (HTML) component.

New HTML Extensions

Microsoft Excel 97 contains many new features for working with Web authoring and supports reading and writing most standard HTML tags. The following four new HTML extensions are included with Microsoft Excel 97: NOTE: Only the Style tag is created when you save a worksheet as an HTML file. The other three tags, Formula, Crosstab, and Filter, are read-only tags; they are not created when you save a worksheet as an HTML text document. Note that a new version of the Internet Assistant Wizard creates the Filter tag. You can download the new Html.xla from the Microsoft Web site.

Formula Tag Example:

 <TD FORMULA="=Sum(A2:B2)">15.67
				

Crosstab (PivotTable) Tag Example:

 <TABLE border CROSSTAB CROSSTABGRAND=ROWCOLUMN>
 <TR>
 <TH ROWFIELD>Store #
 <TH>Date
 <TH PAGEFIELD>Channel
 <TH COLFIELD>Division
 <TH>Product
 <TH DATAFIELD AGGREGATOR="SUM">Units
 <TH>Price
 <TR><TD>Store 2<TD>1/1/96<TD>Wholesale<TD>Brass<TD>Trumpet<TD>7<TD>325
 <TR><TD>Store 6
 <TD>1/8/96<TD>Wholesale<TD>Electronic<TD>Keyboard<TD>8<TD>795
 <TR><TD>Store 5<TD>1/15/96<TD>Wholesale<TD>Brass<TD>Trumpet<TD>4<TD>400
 . . .
 </table>
				

Filter (Autofilter) Tag Example:

 <TABLE>
 <TR>
 <TD FILTER=ALL>Store #
 <TD FILTER=NONBLANKS>Date
 <TD FILTER=ALL>Channel
 <TD FILTER=ALL>Division
 <TR><TD>Store 2<TD>1/8/95<TD>Wholesale<TD>Brass
 <TR><TD>Store 6<TD>1/8/95<TD>Wholesale<TD>Electronic
 <TR><TD>Store 5<TD>1/15/95<TD>Wholesale<TD>Brass
 . . .
 </TABLE>