Excel Export Options

The following additional options can be used for Excel (XLS and XLSX) exports:

Option	Description
-columnwidthmode=option	The method for setting column widths. Valid values for option: reportheader Columns widths are based on objects in the report header pageheader Columns widths are based on objects in the page header groupheader Columns widths are based on objects in group headers detail Columns widths are based on objects in detail sections groupfooter Columns widths are based on objects in group footers pagefooter Columns widths are based on objects in page footers reportfooter Columns widths are based on objects in report footers wholereport Columns widths are based on objects in the whole report fixed Columns use the fixed width specified using the -columnwidth parameter auto Columns are sized automatically Default value: fixed
-columnwidth=size	The column width, if you want fixed-width columns for an Excel export. Set to 0 for automatic column width. If a value other than 0 is specified, the columnwidthmode is treated as "fixed". Default value: 0.
-pageheaderfooter=option	Determines how page headers and footers should be exported. Valid values for option are: none Page headers and footers not exported once Page headers and footers are exported once at the beginning of the report all Page headers and footers are exported for each page
-firstpage=pagenumber	The first page of the page range to export.
-lastpage=pagenumber	The last page of the page range to export.
-convertdates[{+\|-}]	Convert dates to strings. Default value: False.
-gridlines[{+\|-}]	Show grid lines. Default value: False.
-tabheadings[{+\|-}]	Tab has column headings. Default value: True.
-areagroup:index	Group number to base column widths on. Default value: 0.
-groupoutlines[{+\|-}]	Show group outlines. Default value: False.

Related Concepts

Export Formats and Options