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

    Posted 31 Oct 2016 Link to this post


    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?



  2. Boby
    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.

    Telerik by Progress

Back to Top