Add a Microsoft Excel File

Warning
Results may be unpredictable if you have multiple spreadsheets open during processing. You can avoid the issue by staying out of Excel while outputting to a Y device. For long reports, it is advised you output to a more generic file. See Add a File Device.

The following fields are prompted when you opt to add or change a Y Excel file device in Output Device Maintenance (XDM):

Field Name

Type / Max Length

Action / Description

Device name

Display

The device name you specified

Device type

Display

Y Excel file.

Actual device name

Required
8 alphanumeric

Accept the displayed device name or enter the name of the device in your QICWARE system configuration.

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

Select 1 Microsoft Excel 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.

Headings/Total option

Optional

Select which headings to skip or print and whether to print totals:

Select	To
Y	Skip all headings and totals
C	Print column headings and totals
N	Print page headings, column headings and totals
E	Print column headings but do not print totals

Choose the appropriate options:

To	Do This
Change a field	Move the cursor to the field and make changes. Click Apply.to accept the changes or click Cancel to reject the changes.
Enter notes for this device	Enter Notes. See Enter Notes.
Display change history for the device	Click Audit. See Display an Audit Trail. This button is available only if audit trail logging is activated for the Output Device Parameters (DEVICE) file.
Test the device	Click Auto Test. This function is not available for an Excel file.
Accept the data and return to the list of devices	Click OK.
Exit the program	Click Exit.