[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 ?
Thanks so much for the quick response again. They just upgraded the java version from jdk1.8.0_74 to jdk1.7.0_97. We use OpenJDK. But I am having this problem in both the versions in 2 different servers.
Thanks
Shuba
Jan, Do you think that the second issue is also related to the Java settings? 2. I have sequence of jobs. The first job creates the workbook, create a sheet and then saves it. The second job should open the same workbook and append another sheet. But with .xlsx, I am getting the error that the file is not found. Thanks shuba
File not found means file not found.... It is sometimes a timing problem but my API checks the existence of the file before it tries to open it. This helps to find problems much better. Do you use network attached storage? Sometimes NAS file systems have a synchronizing delay.
This is the actual error I am getting 2016-02-11 23:33:13|lQqABm|20160211233302_3NxWK|yPGLrN|GRP_ETL|jo_GRP_RPT_0003_generateServiceSummaryXls_J1|Default|6|Java Exception|tFileExcelWorkbookOpen_1|java.lang.IllegalStateException:Zip File is closed|1 I used an open and save in my previous job that writes this file.
