import xlwings as xw
app=xw.App(visible=True,add_book=False)
wb=app.books.add()

# add worksheet named "Fruits"
wb.sheets.add(name='Fruits')
sheet1 = wb.sheets['Fruits']

# add worksheet named "Vegetables"
wb.sheets.add(name='Vegetables')
sheet2 = wb.sheets['Vegetables']

# Set output file name
file_name = 'output.xlsx'

try:

    # write data to "Fruits" worksheet
    sheet1.range('A1').value = 'Fruits'
    sheet1.range('A2').value = 'Appple'
    sheet1.range('A3').value = 'Banana'
    sheet1.range('A4').value = 'Mango'
    sheet1.range('B1').value = 'Sales in kg'
    sheet1.range('B2').value = 20
    sheet1.range('B3').value = 30
    sheet1.range('B4').value = 15

    # write data to "Vegetables" worksheet
    sheet2.range('A1').value = 'Vegetables'
    sheet2.range('A2').value = 'tomato'
    sheet2.range('A3').value = 'Onion'
    sheet2.range('A4').value = 'ladies finger'
    sheet2.range('B1').value = 'Sales in kg'
    sheet2.range('B2').value = 200
    sheet2.range('B3').value = 310
    sheet2.range('B4').value = 115

    wb.save(file_name)
    wb.close()
    app.quit()
except Exception:
    wb.close()
    app.quit()