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 Table Report 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 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 application users who perform a search using the Search control and wish to export only the data subset that matches the search. There is no limit to the number of rows that may be exported.
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:
The column order in the exported file is the same as the column order in the underlying database table or view schema. To achieve a different export order, we recommend creating a database view with the fields arranged in the desired column order.
The exported data includes column headings in the first row.
Avoiding exporting duplicate records
In certain situations it is possible the exported data set will contain duplicate records if the underlying database table or view does not have a primary key declared in the database or a virtual primary key declared in Iron Speed Designer. Without a primary key, the database may return duplicate records.
Export times out
There is no limit on the number of rows you can export. However, if you are exporting a large number of rows, the export process may time out. You may wish to adjust (increase) the executionTimeout parameter in the httpRuntime section of your application’s Web.config file if you experience time out errors.
Efficiency considerations for Export
You can set the maximum number of rows that can be exported in Excel via the Configure Application tool. By default it is set to 10000. This governs whether the values will be exported to Excel, and whether foreign keys will be exported as foreign key value or display as foreign key.
For example on the products table, it has CategoryId field as a foreign key, which is configured to display Category Name. If the number of products is less than the threshold, then Category Name will be exported into either Excel or CSV as requested. If there are at least as many products as the threshold, then CategoryId will be exported instead of Category Name. In addition, when export is requested to Excel, values will be exported to CSV instead. When the threshold is met, the application user will be prompted about the export from the current table.