Export to Excel

Type of Excel Interface

AQT offers three different methods for exporting to Excel:

Normal	Requires Excel on your PC?	Comments
Normal	Yes	The "traditional" export method. Slow and can sometimes give problems
Bulk exporting	Yes	Much faster than above. Data is exported as a group of row as a time
Native export	No	Exports directly to Excel files. Doesn't require Excel on your PC. The fastest export method.

Both Normal and Bulk export work by using a COM interface to Excel. Excel is invoked on your PC and commands are passed to it. There are occasionally problems with this interface if Excel is unresponsive on in an odd state. Also Excel can sometimes be left in an odd state after the AQT export has completed.

Native Export writes directly to Excel files, so Excel is not invoked during the export. It is the option we recommend.

Options

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.
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).
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.
Native Export	Specifies that Native Export is used.
Excel File Format	When Native Export is used, this gives the format of the Excel file created

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.

Native Export can export to Excel files in a number of different formats. This is specified in the Excel File Format dropdown.