- 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
The Excel export exports a formatted Excel workbooks of the report.
Metadata 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 | Description |
|---|---|
Title | The title of the Excel document in the file properties |
Author | The name of the document author. Appears as "Created by" in the Excel file properties. |
Categories | Custom metadata tag for the document, By default it will have the category of the report in Wyn BI |
Exported workbook properties
Property | Default | Description |
|---|---|---|
Use Compression | True | Indicates whether to use compression when exporting the report to xlsx workbook. |
File Format | XLSX | The file format of the exported workbook: xlsx or the old xls format |
Open XML Standard | Transitional | The level of Open XML document conformance on exporting to xlsx file format. The Excel document generated using Strict cannot be viewed on iOS devices. |
Enable Toggles | False | Indicate whether to export toggles from table details or groups to collapsible rows. |
Pagination | False | Must be set to True if you choose Sheet Per Page for the Sheet Mode property |
Use Default Palette | False | Uses the spreadsheet default color Palette |
Sheet Mode | Sheet Per Page | This setting is used to specify how to split the report pages. Single Sheet exports the entire report as a single sheet. Sheet Per Page exports one sheet per page. Section Per Sheet Each report section is exported to its individual sheet, named accordingly to its Label property. |
Sheet Name | "Sheet" | The prefix of the sheet name. The exported sheet will be named Sheet1, Sheet2,... |
Security Settings
Property | Default | Description |
|---|---|---|
Protected By | empty | Username responsible to password protect the Excel document. |
Write Password | empty | The password required to edit the document. |
Read-Only Recommended | False | When a user opens the exported Excel workbook, a dialog will pop-up to indicate that the file is being opened as read-only. |
Page Settings
Property | Description |
|---|---|
Page Orientation | The orientation of the Excel sheet, Portrait or Landscape |
Paper Size | The paper size of the Excel sheet for printing. |
Filename 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 |