I am trying to populate data into multiple sheets using exce...

[Subbarao Desu]

I am trying to populate data into multiple sheets using excel template option. when I am populating data into single sheet things are working fine but when populating to multiple sheets it is giving the below error.

(FOC1522) ntjprerr: CALLPGM execution error caused by:

(FOC1522) java.util.zip.ZipException: duplicate entry:

(FOC1522) xl/worksheets/sheet2.xml. CPJAVA: Error in processing EXECUTE

(FOC1522) command for Class ibi.jsexcel.JscomExcelZip

Here is the sample code I used. We are on 8202.

TABLE FILE CAR

PRINT *

ON TABLE SET BYDISPLAY ON

ON TABLE PCHOLD AS CARSAMPLE FORMAT XLSX TEMPLATE carsamplenew.xltx SHEETNUMBER 2 OPEN

END

TABLE FILE GGSALES

PRINT *

ON TABLE SET BYDISPLAY ON

ON TABLE PCHOLD AS CARSAMPLE FORMAT XLSX TEMPLATE carsamplenew.xltx SHEETNUMBER 3 CLOSE

END

Appreciate any insights on this if anyone faced it earlier.

Thanks,

Subbu.

[Martin Yergeau]

How is defined your template, does it has at least three sheets

Is it working if you populate to sheet 1 and 2 instead

[John Gelona]

Your template file has to have as many sheets as your are going to populate. Then then "ON TABLE PCHOLD commands should look like this:

APP PATH ibisamp

TABLE FILE CAR

PRINT COUNTRY CAR

ON TABLE HOLD AS SHEET1 FORMAT XLSX TEMPLATE book1.xltx SHEETNUMBER 1

END

-RUN

TABLE FILE CAR

PRINT CAR MODEL

ON TABLE HOLD AS SHEET2 FORMAT XLSX TEMPLATE sheet1.xlsx SHEETNUMBER 2

END

-RUN

TABLE FILE CAR

PRINT MODEL SEG.BODYTYPE

ON TABLE PCHOLD FORMAT XLSX TEMPLATE sheet2.xlsx SHEETNUMBER 3

END

-RUN