python how create excel file with sheets code example

Example 1: see sheets of excel file python

xl = pd.ExcelFile('foo.xls')

xl.sheet_names

Example 2: python write to excel

from openpyxl import Workbook

filename = 'Testwriteexcel.xlsx'
sheettitle = 'Sheetname'

wb = Workbook()
wb['Sheet'].title = sheettitle
sh1 = wb.active
sh1['A1'].value = 'Numbers'
sh1['B1'].value = 'Sqares'
sh1['C1'].value = 'Column 3'

for n in range(1, 1+10):
    sh1[f'A{1+n}'].value = n
    sh1[f'B{1+n}'].value = n**2

try:
    wb.save(filename)
except PermissionError:
    print('File might be opened, please close it before writing')