Is there an API which can help to create a new sheet programmatically through an Excel Add In using Excel JS?
Use the add
method on the WorksheetCollection
object:
https://dev.office.com/reference/add-ins/excel/worksheetcollection#addname-string