https://community.qlik.com/t5/Talend-Studio/cant-write-a-xlsx-file/m-p/2268354#M46941 Hi, <BR />What's your whole workflow Can you print the xlsx file into console by tlogrow without tFileOutputExcel?<BR />Best regards<BR />Sabrina Tue, 24 Dec 2013 01:59:25 GMT Anonymous 2013-12-24T01:59:25Z https://community.qlik.com/t5/Talend-Studio/cant-write-a-xlsx-file/m-p/2268353#M46940 i cant write a xlsx file, get this error: <BR />Exception in component tFileOutputExcel_2 <BR />java.lang.IllegalArgumentException: Invalid sheetIndex: -1. <BR /> at org.apache.poi.ss.formula.SheetRefEvaluator.&lt;init&gt;(SheetRefEvaluator.java:39) <BR /> at org.apache.poi.ss.formula.OperationEvaluationContext.createExternSheetRefEvaluator(OperationEvaluationContext.java:97) <BR /> at org.apache.poi.ss.formula.OperationEvaluationContext.getArea3DEval(OperationEvaluationContext.java:259) <BR /> at org.apache.poi.ss.formula.WorkbookEvaluator.getEvalForPtg(WorkbookEvaluator.java:611) <BR /> at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:493) <BR /> at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:287) <BR /> at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateReference(WorkbookEvaluator.java:653) <BR /> at org.apache.poi.ss.formula.SheetRefEvaluator.getEvalForCell(SheetRefEvaluator.java:51) <BR /> at org.apache.poi.ss.formula.LazyRefEval.getInnerValueEval(LazyRefEval.java:44) <BR /> at org.apache.poi.ss.formula.eval.OperandResolver.getSingleValue(OperandResolver.java:62) <BR /> at org.apache.poi.ss.formula.eval.TwoOperandNumericOperation.singleOperandEvaluate(TwoOperandNumericOperation.java:29) <BR /> at org.apache.poi.ss.formula.eval.TwoOperandNumericOperation.evaluate(TwoOperandNumericOperation.java:35) <BR /> at org.apache.poi.ss.formula.functions.Fixed2ArgFunction.evaluate(Fixed2ArgFunction.java:33) <BR /> at org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:119) <BR /> at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:491) <BR /> at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:287) <BR /> at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateReference(WorkbookEvaluator.java:653) <BR /> at org.apache.poi.ss.formula.SheetRefEvaluator.getEvalForCell(SheetRefEvaluator.java:51) <BR /> at org.apache.poi.ss.formula.LazyRefEval.getInnerValueEval(LazyRefEval.java:44) <BR /> at org.apache.poi.ss.formula.eval.OperandResolver.getSingleValue(OperandResolver.java:62) <BR /> at org.apache.poi.ss.formula.WorkbookEvaluator.dereferenceResult(WorkbookEvaluator.java:543) <BR /> at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:506) <BR /> at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:287) <BR /> at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:229) <BR /> at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:264) <BR /> at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCell(XSSFFormulaEvaluator.java:151) <BR /> at org.talend.ExcelTool.evaluateFormulaCell(ExcelTool.java:303) <BR /> at org.talend.ExcelTool.writeExcel(ExcelTool.java:290) <BR /> at vox2.acd_reporting_1_0.acd_reporting.tFixedFlowInput_3Process(acd_reporting.java:1265) <BR /> at vox2.acd_reporting_1_0.acd_reporting.tFileCopy_1Process(acd_reporting.java:985) <BR /> at vox2.acd_reporting_1_0.acd_reporting.tFileExist_1Process(acd_reporting.java:7496) <BR /> at vox2.acd_reporting_1_0.acd_reporting.tJava_2Process(acd_reporting.java:7730) <BR /> at vox2.acd_reporting_1_0.acd_reporting.tJava_1Process(acd_reporting.java:7629) <BR /> at vox2.acd_reporting_1_0.acd_reporting.runJobInTOS(acd_reporting.java:8029) <BR /> at vox2.acd_reporting_1_0.acd_reporting.main(acd_reporting.java:7786) <BR />who can help me? Mon, 23 Dec 2013 14:48:03 GMT https://community.qlik.com/t5/Talend-Studio/cant-write-a-xlsx-file/m-p/2268353#M46940 richie1985 2013-12-23T14:48:03Z https://community.qlik.com/t5/Talend-Studio/cant-write-a-xlsx-file/m-p/2268354#M46941 Hi, <BR />What's your whole workflow Can you print the xlsx file into console by tlogrow without tFileOutputExcel?<BR />Best regards<BR />Sabrina Tue, 24 Dec 2013 01:59:25 GMT https://community.qlik.com/t5/Talend-Studio/cant-write-a-xlsx-file/m-p/2268354#M46941 Anonymous 2013-12-24T01:59:25Z