[]
        
(Showing Draft Content)

Excel Data

The Excel Data export exports the report raw data of the report to an Excel workbook.

Misc Properties

The following properties will appear as metadata for the exported Excel workbook and can be viewed by the user in a spreadsheet program from the file properties dialog box.

Property

Default

Description

Title

{ReportName}

The title of the Excel document in the file properties

Author

default Wyn username

The name of the document author. Appears as "Created by" in the Excel file properties.

Categories

<empty>

Custom metadata tag for the document, By default it will have the category of the report in Wyn BI

Open Xml Standard

Transitional

The level of Open XML document conformance on exporting to xlsx file format.

Use Compression

True

Indicates whether to use compression when exporting the report to xlsx data.

Right To Left

False

Set to true for languages that are read from right to left.

Allow Images

True

Allows images to be exported.

Auto Row Heights

False

Set to true to enable to row height to be set automatically.

File Name Properties

Property

Description

Template

A string template for the exported file name. By default, it consists of the {ReportName} variable but could include fixed strings and the dynamic Rendered Report Values defined in the report info panel. For example, you could set the template to "{ReportName}_{Title}".

Add Timestamp

Adds the time of export to the end of export file name