Page History

...

2.      To write the Excel document using the template you need to add the USING keyword to the ExcelService CREATE command. Your code should look like the following:

#jsmxcmd := 'CREATE USING(training/Employs.xlsx)'
USE BUILTIN(jsmx_command) WITH_ARGS(#jsmxhdle1 #jsmxcmd) TO_GET(#jsmsts #jsmmsg)
EXECUTE SUBROUTINE(CHECK_STS) With_Parms(#JSMXHDLE1)

3.      You now need to write the working list of employees to Row 5, Column 2. Modify your WRITE command as required. Your code should look like the following:

* Write to Excel file
#jsmxcmd := 'WRITE R1C1(5,2)'
USE BUILTIN(jsmx_command) WITH_ARGS(#jsmxhdle1 #jsmxcmd) TO_GET(#jsmsts #jsmmsg #employs)
EXECUTE SUBROUTINE(CHECK_STS) With_Parms(#JSMXHDLE1)

4.      Save your file.  The training directory should be in your Integrator instance directory. Your code should look like the following:

* Save to Excel file
#jsmxcmd := 'SAVE FILE(training/jsmemp' + #datetimec + '.xlsx)'
USE BUILTIN(jsmx_command) WITH_ARGS(#jsmxhdle1 #jsmxcmd) TO_GET(#jsmsts #jsmmsg #employs)
EXECUTE SUBROUTINE(CHECK_STS) With_Parms(#JSMXHDLE1)

5.      Compile function iiiFN13.