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 |
Copies is the number of copies to print. From is the
number of the first page to print. To is the
number of the last page to print. 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