How to insert dropdown or checkbox in Excel using Javascript API

Question

I'm following the doc (https://dev.office.com/reference/add-ins/excel/excel-add-ins-reference-overview) to build an Excel add-in. The add-in needs to populate an Excel table column with either dropdown or checkbox for the user to select actions to be done on the table row. I can't seem to find any API to insert a dropdown/checkbox in the Excel spreadsheet. Could someone advise how I could do that?

Answer 1

Office-js does not support UI controls like text boxes, checkboxes, buttons, and so on. Instead, you would need to accept these user inputs through your task pane or dialogue box. The data validation API, which is still in beta, can be used to include drop-down values within cells and help with managing input values. Alternatively, you could accept inputs within Excel cells as well (though it is a little difficult).

I hope this helps you.