- 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 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 | 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 document to an Xlsx data file. |
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 | Indicates whether to export toggles from table details or groups to collapsible rows. |
Use Default Palette | False | Uses the spreadsheet default color Palette |
Sheet Mode | Sheet Per Page | Single Sheet exports the entire report as one sheet. Sheet Per Page exports one sheet per page.Section Per Sheet ??? |
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 | User Name 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 |