Defining Export Properties for HTML in the Pivot and OLAP Sections

Before exporting data to HTML, use the Export Properties dialog box to specify export properties for data in the Pivot section.

  To specify export properties:

  1. Select Format, then Export Properties.

    The Export Properties dialog box is displayed.

  2. Specify the number of vertical rows to include on an HTML page before starting a new page (file) by checking the Vertical Page Break check box and entering the number of row or pixels.

    The default setting is 100 rows per HTML page. (Select Pixels to specify the number of pixels instead of rows). To export to one file, or to have no page break, leave the Vertical Page Break check box blank.

  3. Specify the number of horizontal columns to include on an HTML page before starting a new page (file) by checking the Horizontal Page Break check box and entering the number of columns or pixels.

    The default setting is 100 rows per HTML page. (Select Pixels to specify the number of pixels instead of rows). To export to one file, or to have no page break, leave the Horizontal Page Break check box blank.

  4. Select the desired export properties.

    Check the Export with Style Sheet (CSS) option to create a Cascading Style Sheet file separate from the HTML file. If this field is unchecked, the style sheet information is embedded in the HTML file itself.

  5. For data exported to tab-delimited text files, select the Export Without Quotes check box to exclude double quotation marks around real column/cell values in the exported files.

  6. Click OK.