Excel Export Options Page

The Excel Export Options page is available if you select Excel (XLS or XLSX) or Excel Data Only as the export format.

Page Headers and Footers

Controls how page headers and footers will be exported.

Column Widths

Controls how the column widths will be set in the resulting Excel document.

Automatic

The columns will be sized based on their content. If you want to base the sizing on the content in a particular section, you can select it here.

Constant column width

All columns will be set to the fixed width you specify.

Formatting

The Formatting section contains additional options to control formatting. The options available depend on whether you are exporting to Excel or Excel Data-Only format. These options correspond to the options available when exporting from the Crystal Reports report designer.