Any way to create a new worksheet using xlwings?

Question

Using Python xlwings, how can I create a new worksheet?

Answer 1

import xlwings as xw
wb = xw.Book()
wb.sheets.add()

See also the docs.

Answer 2

I use the following helper function to add a sheet if it is not yet existing or get/activate it, in case it is already present:

def addActivate(wb, sheetName, template=None):
    try:
        sht = wb.sheets(sheetName).activate()
    except com_error:
        if template:
            template.sheets["Template"].api.Copy(wb.sheets.active.api)
            sht = wb.sheets["Template"].api.Name = sheetName
        else:
            sht = wb.sheets.add(sheetName)
    return sht

It also allows to define the name of a sheet name to be used as template for the new sheet.