- Getting Started
- Administration Guide
-
User Guide
- An Introduction to Wyn Enterprise
- Document Portal for End Users
- Data Governance and Modeling
- Working with Resources
- Working with Reports
- Working with Dashboards
- View and Manage Documents
- Understanding Wyn Analytical Expressions
- Section 508 Compliance
- Subscribe to RSS Feed for Wyn Builds Site
- Developer Guide
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 |