PreviousNext
Help > Programming with LAUNCHER Office > LNCCMD commands > Commands list > XLPRINT command
XLPRINT command

 Prints an Excel workbook.

 

Syntax

CHGVAR

VAR(&CMD) VALUE('XLPRINT')

CHGVAR

VAR(&PARM1) VALUE('

[Printer="Nom_imprimante"]

[;Copies="Nombre_de_copies"]

[;From=Number]

[;To=Number]

[;Preview=True/False]

[;PrintToFile="Chemin fichier"]

[;Collate=True/False]

[;Workbook=True/False]

[;Sheet=True/False]

[;Selection= True/False]

')

CHGVAR

VAR(&PARM2) VALUE(' ')

CALL

PGM(LNCCMD) PARM(&HANDLE &CMD &OPT &PARM1 +

&PARM2 &RESULT)

 

Parameters

Parameters

 

Parm1


Printer is the name of the printer.
If Printer is not specified, the default printer is used (see Windows Configuration Panel).

Copies is the number of copies to print.

From is the number of the first page to print.
From refers to the printed pages, not overall pages of the sheet or workbook.

To is the number of the last page to print.
To refers to the printed pages and not overall pages of the sheet or workbook.

Preview to preview print.

PrintToFile prints to a file. You must specify the path and file name.

Collate allows you to have collated copies. Organizes numbered pages when you print multiple copies of a document. A complete copy of the document is printed before printing the first page of the second copy.

Workbook or Sheet or Selection to select the object to print.

 

Example

 

CHGVAR

VAR(&CMD) VALUE('XLPRINT')

CHGVAR

VAR(&PARM1) VALUE('Printer="Brother HL-1270N series";

From=2;"To=8;Sheet')

CHGVAR

VAR(&PARM2) VALUE(' ')

CALL

PGM(LNCCMD) PARM(&HANDLE &CMD &OPT &PARM1 +

&PARM2 &RESULT)

Pages 2 to 8 of the current sheet are printed on the "Brother HL-1270N series" printer.

 

LNCCMD CMD(XLPRINT) PARM1('printer="LBP611C";Workbook')

 

The entire workbook is printed on the printer "LBP611C".

 

See Also 

WPRINT