Hello,
I'm using aspose.cells for java.
Is the function VLOOKUP supported ?
I tried "VLOOKUP(A5,PromDet!A$2:I$65500,8,0)" but without succes
Thanks
Hi,
Yes, VLookup function is supported. It seems that you are using some older version of Aspose.Cells for Java. Kindly try the attached version (latest).
I have tried the following sample code using a template file and it works.
Workbook workbook = new Workbook();
workbook.open("e:\\files\\MyBook.xls",FileFormatType.EXCEL2003);
workbook.getWorksheets().getSheet(0).getCells().getCell("E33").setFormula("=VLOOKUP(A5,Sheet2!A$1:I$65500,2,0)");
workbook.calculateFormula();
System.out.println(workbook.getWorksheets().getSheet(0).getCells().getCell("E33").getStringValue());
workbook.open("e:\\files\\MyBook.xls",FileFormatType.EXCEL2003);
workbook.getWorksheets().getSheet(0).getCells().getCell("E33").setFormula("=VLOOKUP(A5,Sheet2!A$1:I$65500,2,0)");
workbook.calculateFormula();
System.out.println(workbook.getWorksheets().getSheet(0).getCells().getCell("E33").getStringValue());
Thank you.