Export Collection to Excel dialog box
Use the Export Collection to Excel dialog box to export the current collection to a comma separated file. Once you specify the folder where the file is to be saved, you are prompted whether to open the file in Microsoft Excel. Each record in the collection becomes a row in the exported file. Each field (property) becomes a column in the exported file.
This table lists the elements in this dialog box and explains their use.
| Element | Function/Comments |
|---|---|
|
The text box for the path is set to the default path when this dialog appears. The default path is the last folder that was selected in a previous export operation. If no path is specified when you attempt to save the file, this dialog prompts you to specify the destination folder. Click this button to locate the folder where the file is to be saved. Note: The system saves the file in the My Documents folder
by default. If you have previously selected a folder, that folder is
used as the default.
|
|
| Match sequence of columns in the related grid. | If the spreadsheet columns should match the order of
the grid columns on the form, select this option (which is selected by
default). If the spreadsheet columns should match the order of the property list in the form's IDO, clear this option. |
To access this dialog box, select from the menu, or click the "Export data to Excel" button on the toolbar.