Comparison of HTML File Format Types

The following table shows which export attributes are supported by the HTML file format.

Table 1. Comparison of HTML File Formats 

Section

Office HTML Export to Office Excel

Standard HTML Export to Excel

Results/Table

Formatting is preserved.

Formulas are supported. (See Formula Mappings).

Formatting is not preserved.

Formulas are not supported.

Pivot

Export preserves formatting.

Cell merging is supported.

Export does preserve formatting.

Export does not support formulas.

Cell margins are not supported.

Chart

The Chart section is written to two worksheets: the first worksheet contains the Chart data in a table, and the second worksheet contains the Chart image.

Exported Chart data is aggregated in the same way as in the original Chart section.

Tip:

When a Chart section has been exported to Excel, you can use the data in the table as a data source and launch the Excel Chart Wizard to create the actual Chart. The rendered Chart looks the same as the one created in Interactive Reporting Studio.

The Chart data is written to a simple table.

Report

The Report data is written to a simple table.

If a report has only one table or one pivot (no matter how many pictures and or text labels are in the report), column widths are preserved. Otherwise column widths are not maintained. Column width, in this case, is resized to fit data from any table.

Formatting is preserved.

Report elements including: text, labels, images, tables, pivots, and charts are placed one after another vertically. A vertical gap of a certain fixed height exists between two elements. If elements overlap vertically by a small value, these elements are shown with no gap between them. This is to accommodate any design that includes stacked elements. The gap is one row high.

Report headers/footers are output.

Graphical elements such as lines, circles are not supported.

Overlapping tables are not supported and are computed consecutively.

Page headers/footers are not supported.

The Report data is written to a simple table.

Dashboard

Not supported except as an image in the export feature.

Not supported

EPM WorkspaceExport to Office 2000 is not supported by way of Toolbar or MenuNot supported by way of Toolbar or Menu