Hands-on Python Openpyxl Tutorial With Examples Add Sheets To The Excel File. Considering the above example to track the report of every day, we need to create a new sheet for each day. To add new sheets to the Excel, use the create_sheet command. Syntax: create_sheet(title=None, index=None) Create a worksheet (at an optional index). Parameters: title (str): optional title of the sheet.