Search code examples
office365office-jsexcel-addins

Creating a new sheet programmatically using Office JS


Is there an API which can help to create a new sheet programmatically through an Excel Add In using Excel JS?


Solution

  • Use the add method on the WorksheetCollection object:

    https://dev.office.com/reference/add-ins/excel/worksheetcollection#addname-string