VLOOKUP?

2 posts, 0 answers
  1. Guy
    Guy avatar
    18 posts
    Member since:
    Oct 2012

    Posted 31 Oct 2016 Link to this post

    Hi

    Using Telerik.Windows.Documents.Spreadsheet.Model.Workbook class, it seems there is no VLOOKUP function, although there is a LOOKUP function which works almost the same way. The lack of VLOOKUP specifically impacts my ability to load existing Excel documents. Is there a way to add a VLOOKUP function to the SpreadProcessing engine?

    Thanks,

    Guy

  2. Boby
    Admin
    Boby avatar
    603 posts

    Posted 01 Nov 2016 Link to this post

    Hi Guy,

    VLOOKUP function is currently not supported. I can see that you are already following the item in our feedback portal, so you'll get notified in case of status changes:
    Spreadsheet: Implement the VLOOKUP function

    There is API for adding custom functions, so you can try to implement it yourself. You can check the help article here: Custom Functions.

    Regards,
    Boby
    Telerik by Progress

Back to Top