Search code examples
exceloffice-js

How to launch the Select Data dialog in Excel from a JS add-in


How do I launch the "Select Data" dialog in Excel from a JavaScript add-in so the user can select a cell for the add-in to add data?


Solution

  • I have been able to do this using the addFromPromptAsync method. There is a great writeup on this here: https://stackoverflow.com/a/44425179/11453853