Search code examples
exceloffice-jsexcel-addins

Pre-populating Cells with Multiple Values using Office JS

I am building an Excel Add In for Office 365 using Office JS. I am keen to provide some of the cells in the Excel Sheet to have pre-populated drop down of values for users to choose from while entering the data in the Excel Sheet. The template for the Excel sheet is generated the first time the user loads the Add In. Is there an Office -JS API which allows the same?

Solution

  • At this point in time we do not have an API to add Data Validation (which adds the drop-downs to Excel Cells). Feel free to log a feature request at https://officespdev.uservoice.com/ and we will consider adding an API for this in the future.

    -Philip, Software Developer on the Office Extensibility team