Set Up A Microsoft Excel Output Device

Field Name

Type / Max Length

Action / Description

Device name

Required
8 alphanumeric

Enter a unique identifier for this device type.

Device type

Required
1 alpha

Select Y.

Actual device name

Required
8 alphanumeric

Enter the device name of the QANTEL Print Connector in your QICWARE system configuration.

The system checks the status of this device to verify that it is a real device.

Device description

Optional
40 alphanumeric

Enter a description for this device. This description displays to the right of device name when you select an output device in a print program.

Special output type

Optional
1 alphanumeric

Select 1 to output directly to Excel. QANTEL Print Connector must be installed on the PC that uses this device. QANTEL Print Connector launches Excel and transfers the data directly into a spreadsheet.

Skip headings

Optional

Select which headings to skip or print:

Select

To

C

Skip page headings and print column headings

N

Skip neither; print both page and column headings

Y

Skip both page and column headings; print neither

Change negative sign?

Optional

Select to place the negative sign (-) to the left of the number or leave blank to place it to the right.

If the negative sign is to the right, Excel does not consider the data to be numeric.