Problème avec la formule RECHERCHEV (api jxl )
Bonjour ,
j'ai un souçi concernant l'execution d'une fonction RECHERCHEV à partir d'un fichier Java en utilisant L'api jxl
Code:
1
2
3
4
5
6
7
8
|
Formula formule = new Formula(
0,
0,
" =RECHERCHEV(Feuil1!B4,m!A:B,2)");
sheet.addCell(f1); |
Merci pour votre aide
resultat :
[/CODE]
Warning: Could not find named cell m when parsing formula =RECHERCHEV(B2,m!A:B,2) in cell Feuil1!D3
Error:
jxl.biff.formula.FormulaException: Unrecognized function
at jxl.biff.formula.StringFormulaParser.handleFunction(StringFormulaParser.java:354)
at jxl.biff.formula.StringFormulaParser.parseCurrent(StringFormulaParser.java:144)
at jxl.biff.formula.StringFormulaParser.parse(StringFormulaParser.java:113)
at jxl.biff.formula.FormulaParser.parse(FormulaParser.java:161)
at jxl.write.biff.FormulaRecord.initialize(FormulaRecord.java:177)
at jxl.write.biff.FormulaRecord.setCellDetails(FormulaRecord.java:243)
at jxl.write.biff.WritableSheetImpl.addCell(WritableSheetImpl.java:1199)
at Main.main(Main.java:138)
Exception in thread "main" java.lang.NullPointerException
at jxl.write.biff.FormulaRecord.getFormulaData(FormulaRecord.java:293)
at jxl.write.biff.FormulaRecord.getData(FormulaRecord.java:255)
at jxl.biff.WritableRecordData.getBytes(WritableRecordData.java:71)
at jxl.write.biff.File.write(File.java:147)
at jxl.write.biff.RowRecord.writeCells(RowRecord.java:342)
at jxl.write.biff.SheetWriter.write(SheetWriter.java:480)
at jxl.write.biff.WritableSheetImpl.write(WritableSheetImpl.java:1558)
at jxl.write.biff.WritableWorkbookImpl.write(WritableWorkbookImpl.java:950)
at Main.main(Main.java:141)
[/CODE]
