Is it possible to load List of values in excel using VSTO web add-ins using office.js RRS feed

  • General discussion

  • I am developing a excel add-in using office.js, that populates table data in excel sheet. Add-in allows user to update table column details, but I want to display list of reference values rather than free text. Example for scenario is given below. 

    Table displayed in excel will have two columns Column 1 And Column 2, I will have reference data  in reference table, When user want to update column 2 I want user to select only allowed values from reference table, but I don't see any options available in office.js library. Please guide me If any of you have any suggestions to achieve my need.

    I am loading table using offfice.js objects as given below

    var data = serverTableObjectAsArray;                                         
    var officeTable = new Office.TableData(); 

    Sunday, December 3, 2017 10:34 AM