One Star

tFileInputExcel : common Assertion.failed

Hi ,
in a simple job tFileInputExcel --->tMap--->tFileoutputDelimited I am using a Excel file (10 Mb big) which has 20 worksheets , worksheets' names are for example 'Paramètres saisie' , 'Mode opératoire" , 'Suivi des modifications' etc ...
In medata repository I defined a scheme for managing only the worksheet named 'Suivi des incidents".
Regarding error message I tried to define String fields or Date fields for managing this file but the error message stays the same and is :
common.AssertionFailed
at common.Assert.verify(Assert.java:37)
at jxl.read.biff.WorkbookParser.getName(WorkbookParser.java:1117)
at jxl.biff.formula.NameRange.read(NameRange.java:88)
at jxl.biff.formula.TokenFormulaParser.parseSubExpression(TokenFormulaParser.java:214)
at jxl.biff.formula.TokenFormulaParser.parse(TokenFormulaParser.java:111)
at jxl.biff.formula.FormulaParser.parse(FormulaParser.java:110)
at jxl.biff.DVParser.<init>(DVParser.java:428)
Complete error message in attached images.
Would you have some suggestion about this issue ?
With best regards,
Yves .
1 REPLY
Community Manager

Re: tFileInputExcel : common Assertion.failed

Hi Yves
From the error message, seems it can't parse the sheet name and pass null value to the method getName(). In order to locate the problem, try to rename the sheet name to a simple name in English and test again.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business