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')