I want to append data to existing excel file in new sheet.How I can achieve that ?
but i am getting below error.
[statistics] connecting to socket on port 3854 [statistics] connected Exception in component tFileOutputExcel_3 (ExtractMetadata) org.apache.poi.EmptyFileException: The supplied file was empty (zero bytes long) at org.apache.poi.util.IOUtils.peekFirstNBytes(IOUtils.java:65) at org.apache.poi.util.IOUtils.peekFirst8Bytes(IOUtils.java:48) at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:177) at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:144) at org.talend.ExcelTool.prepareXlsxFile(ExcelTool.java:114) at local_project.extractmetadata_0_1.ExtractMetadata.tSalesforceInput_1Process(ExtractMetadata.java:6322) at local_project.extractmetadata_0_1.ExtractMetadata.runJobInTOS(ExtractMetadata.java:8265) at local_project.extractmetadata_0_1.ExtractMetadata.main(ExtractMetadata.java:8114) [statistics] disconnected
Job ExtractMetadata ended at 15:01 17/09/2018. [exit code=1]
did you check all row1 date dataType? did you syncronise datatype on tOutputExcelFile2? can you click and desactivate all unused components to validate error location. can you click on code tab to check java error? (red underlined)
