This builder lets you export table-like XML data as a spreadsheet file.
The XML data that is used by the Spreadsheet Export builder can be obtained from a page location or an indirect reference in your model. If the data is exported from a page location, the builder makes its best attempt to export the data in a way that preserves the look and feel of the data displayed at the specified page location.
This builder is not designed for bulk data handling. Do not use a spreadsheet file as a primary data source. Use this builder for reporting only.
You can use the Spreadsheet Export builder to derive localized and readable header labels. In a Localized Resource builder, enable the Create Lookup Table
input and, in this builder, use the Header Lookup Table
input to select the lookup table.
When XML is exported, one of two events happen:
- The user's browser automatically launches the related spreadsheet program and displays the exported spreadsheet.
- The user's browser displays a Save As dialog and gives them an option to save the exported file.
Which event the user sees depends upon how the user's browser is configured and whether or not the related spreadsheet program is installed on the computer.
On a Windows® system, if the downloaded spreadsheet document does not open, change your configuration. In Windows Explorer, click Tools
-> Folder Options
-> File Types
. Then click either XLS
. Under Actions
, click Open
, set Confirm open after download
, and clear Browse in same window
. Then, click OK
Exclamation character in sheet name
An open document spreadsheet (.ODS format) that contains a sheet with a name that has the exclamation character (!) cannot be processed by the either the Spreadsheet Export builder or the Spreadsheet Import builder. Spreadsheet program installation required for viewing
The builder works in conjunction with the spreadsheet program for viewing exported data. A copy of spreadsheet program must be installed on those computers where a user wishes to view the exported content as a spreadsheet.Formulas and charts
Because the source data used for export does not contain any spreadsheet metadata (for example, formulas and charting), the exported spreadsheet contains only data and formatting that can be determined by the builder from the source XML (page location or indirect reference).Microsoft® Office Excel View 2003
Parent topic: Builder help
About using the builder call editor
Locating control builder calls on pages