Cacher is the code snippet organizer for pro developers

import os
import openpyxl

os.chdir('c:\\users\\torre\Desktop\\Excel Playground')

wb = openpyxl.Workbook()

sheet = wb['Sheet']

sheet['A1'].value = 42
sheet['A2'].value = 'Hello'

wb.save('python_example.xlsx')

sheet2 = wb.create_sheet()

sheet2.title = 'My New Sheet Name'

print(wb.sheetnames)

wb.save('example2.xlsx')

wb.create_sheet(index=0, title='My Other Sheet')

wb.save('example3.xlsx')