Is it possible to add a button on Excel sheet using Office Js Api?

Question

I am building an Excel Addin using Office JS API. I have found a workaround to dynamically generate drop-down lists and now I am wondering whether I can add a Button on excel sheet using Excel JS API

Answer 1

While you cannot add a button through the Exel Javascript Library, you can format a cell to look like a button and have it execute your javascript code when clicked. See a post I wrote on this: Excel Office.js -add button on Workbook_Open() envent

Answer 2

It seems that currently there is no way to add a button to the spreadsheet itself with the Excel JavaScript Library.