Bonjour ,

j'ai un souçi concernant l'execution d'une fonction RECHERCHEV à partir d'un fichier Java en utilisant L'api jxl

Code : Sélectionner tout - Visualiser dans une fenêtre à part
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]