Settings for the Grid to Excel and Database to Excel Options

When data is exported to Excel spreadsheets using the Grid to Excel and Database to Excel options, the spreadsheets are generated using a default template supplied with the product. To select a different template, press the ... button at the end of field in the Excel template file section and browse for the required template. The name and location of the selected template is then displayed in the field.

Note: When creating an Excel template, to specify the first cell in which data is to be placed, select the Properties from the File menu in Excel. On the Summary tab of the Properties dialog, enter the start cell in the Comments field. For example:

If the application is being run on Windows 7 SP1, the above facility is not available. A start cell must be specified in the Start Cell Value field of the Options tab instead.

If the application is being run on other operating systems, if a start cell is also specified on the Options Tab, this overrides the start cells specified for individual templates using the above dialog.

• When data is exported to Excel spreadsheets using the Database to Excel option, if the width of columns in the spreadsheets is to be automatically adjusted to the width of the data they contain, check the Adjust Column Width checkbox.

• When data is exported to Excel spreadsheets using the Database to Excel option, if custom (for example, used-defined) queries are to be available when specifying the report contents, check the Use Custom Queries checkbox.