Allows you to create a PDF for each sheet of an Excel workbook passed as a parameter. Each PDF will have the name of the Excel sheet followed by the extension ".PDF"..
Syntax
|
CHGVAR |
VAR(&CMD) VALUE('PDFALLXL') |
|
CHGVAR |
VAR(&PARM1) VALUE('XL="Path of the Excel workbook"') |
|
CHGVAR |
VAR(&PARM2) VALUE(' ') |
|
CALL |
PGM(LNCCMD) PARM(&HANDLE &CMD &OPT &PARM1 + &PARM2 &RESULT) |
Parameters
|
Parameters |
|
|
Parm1 or Parm2
|
XL: Complete path of the Excel workbook.
|
Example
LNCCMD CMD(PDFALLXL) PARM1('XL="c:\A\test.xlsx"')