[resolved] Writing to two sheets in the same excel file from one job
Hi all, I have a problem writing to two different sheets in the same excel file from the same job, below is the scenario : tFileInputExcel - > tMap -> tReplicate .. replicate1 .. -> tFileOuputExcel(sheet1) .. replicate2 .. -> tMap -> tFileOuputExcel(sheet2) tFileOuputExcel is the same file. If I change one of the tFileOutputExcel file name to a different file name, then both files are created with the respective sheet names(sheet1, sheet2), however they are in different files which does not suite my purpose. Is this a bug in Talend ?
All that I am doing is creating an empty .xlsx workbook in the first subjob, writing a sheet in it and save the workbook using the custom component and in the second subjob if I try to open the same workbook, it thros an error that the workbook is closed. cannot open file.
This is the java exception of the error: 2016-02-16 08:27:12|8ANK5U|20160216082700_VwPOp|CafRzf|GRP_ETL|Copy_of_jo_GRP_RPT_0003_generateInvoicesByEntityTypeXls_J_Good|Default|6|Java Exception|tFileExcelWorkbookOpen_1|java.lang.IllegalStateException:Zip File is closed|1
