Free Support Forum - aspose.com

Vlookup

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());
Thank you.