Query on Vlookup/ VBA Macro


#1

Hi -

I tried using Vlookup API function using Aspose.Excel for .net, i always get a return value "0" after calculating the formula at run time which is not correct. The same formula works if i apply directly in spreadsheet.

Below are the product details i work with

Aspose Version: 3.5.1.0

Excel Version: 2000

I used licenced version that to i believe it is Enterprise edition.

Attached below is the excel file with .net soln i tested.

I already sent the same content to this email nanjing@aspose.com. which i got from forum.

Any help with quick turnaround is greatly appreciated.

Thanks

-Bala


#2

VLookup functions is not supported in the calculation engine. We will investigate and implement it. It will be available within one or two weeks.