Export to Microsoft Excel
By default, Iron Speed
Designer’s Application places an “Export to Excel” button in each table panel,
such as is found on a Show Table page. Exported files are saved in a special XML file
format that is recognized and imported by Microsoft Excel.
Excel
Versions Supported
The Export to Excel feature works on Microsoft
Excel 2003, Microsoft 2007 and later versions.
The Export to Excel feature uses the new Excel XML format that Microsoft
developed for Excel 2003 and Excel 2007.
Microsoft Excel 2000 does not support the
Excel XML format and hence the data is displayed as XML in an Excel 2000 file. There may be an Excel 2000 add-in that provides
this feature at http://support.microsoft.com/default.aspx/kb/924074.
Exported
Data Rows
Only the rows in the
currently displayed data set are exported.
This is convenient for end-users who perform a search using the Search
control and wish to export only the data subset that matches the search.
Exported
Data Columns
The exported rows include all data fields displayed
in the associated table control; fields that are not displayed are not
exported. There are several caveats:
|
Column Type
|
Caveat
|
|
Date fields
|
Date fields are exported as per their
display format strings and will be exported as they are displayed in the Show
Table panel.
The default format is m/d/yyyy
|
|
Currency, number and percentage fields
|
Currency, number and percentage fields are
exported as numeric values to enable sorting in Microsoft Excel.
The default formats are:
|
Currency fields
|
#,##0.00
|
|
Number fields
|
#,##0
|
|
Percentage fields
|
0.00%
|
|
|
Foreign key fields
|
Foreign key fields are
exported as shown in the table control.
If the “display foreign key as” is set for the field, then the
selected text field will be exported instead of the underlying key value.
|
|
Password fields
|
Password fields are exported
as shown in the table control.
|
|
Large text fields
|
Large text fields, such as the Memo field in
Microsoft Access and the nText data type in Microsoft SQL Server, are
exported as text strings.
Word-wrapping in Excel is automatically
enabled for large text fields.
|
|
Binary and image fields
|
Binary fields, such as
Image and BLOB's (binary large object), are not exported.
|
The column order in the exported file is the
same as the column order in the database table schema.
The exported data includes column headings in
the first row.
See
Also
Creating
Your First Application
Function
Buttons
PDF
Report
Microsoft
Word Report
Export
to Microsoft Excel
Export
to ASCII CSV