Excel Data-Only Export Options

Formatting Options

When you export to Excel Data-Only, the following additional command-line options are valid:

-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

-exportformatting

Export formatting for objects. If not specified, formatting for objects is not exported.

-maintainalignment[{+|-}]

Maintain column alignment. Default value: True.

-maintainposition[{+|-}]

Maintain relative object position. Default value: False.

-simplifyheaders[{+|-}]

Simplify page headers. Default value: True.

-worksheetfunctions[{+|-}]

Use worksheet functions for summaries. Default value: True.

-exportimages[{+|-}]

Export images. Default value: True.