Export to Excel

In order to use this feature, you must have Excel installed on your PC.

Options you can specify for Export to Excel are:

Option	Description
Worksheet	The name of the Worksheet the data is to be exported to. If this worksheet doesn't exist, it will be created. If it does exist, the Replace Worksheet or Append Data options will control how whether this worksheet is replaced or appended to. In other words, for Excel, Replace / Append operates at the Worksheet level rather than at the file level.
Start Cell	Specifies the cell in the worksheet where AQT will start to write the results.
Use bulk exporting of data	When this option is checked, AQT will load data using a bulk loading method. This is a lot faster than loading the data a cell at a time. This method may not be available for older versions of Excel. If you are having problems exporting data to Excel, you may need to de-select this option.
Worksheet password	This sets a password on the exported worksheet. The worksheet can not be amended or overwritten until you Unprotect the worksheet (you do this within Excel).

After it has finished writing the data, AQT will automatically save the workbook and leave it open for you to view.

AQT will set the format of the cells in the worksheet according to the data type of the columns. Date, time and timestamp columns will be displayed in Excel with the same date format as defined to AQT (see Options > Display Format).
The decimal part of timestamp values will be truncated. Excel timestamps do not have a decimal component.
If you use dates prior to 1 Mar 1900, you may notice the dates may be out by one day. This is a bug with Excel, which is described here.

Exporting LOBs

If your data has LOBs (such as images or ducuments) AQT can export these to separate files and create hyperlinks to them from your Excel worksheet. See Exporting LOBs for more on this.

Hyperlinks

If AQT sees that a column value starts with http:// it will assume that this is a url and will create a hyperlink to that address.

Excel Crash when using exporting large columns

Some users have experienced crashes of Excel when exporting very large column columns (several thousand bytes). This problem only happens when Bulk Exporting has been selected. To prevent this problem from happening, de-select Use bulk exporting of data.

Exporting to Excel 2007 Files and XML Worksheets

AQT supports both these types of Excel files. When you select an Excel file to save, enter a file name with an extension of:

xlsx (for Excel 2007 file)
xml (XML Worksheet)

If you are creating a new file, the Windows "Save as" dialog will not add this file extension to your file name, even if you have selected this in the "Save as Type" dropdown. You must manually include this file extension in your file name.