python excel file read and write code example

Example 1: python write to excel file

from openpyxl import Workbook

row = 1
wb = Workbook()
wb['Sheet'].title = "Report of Automation"
sh1 = wb.active
sh1['A1'].value = 'Name'
sh1['B1'].value = 'Status'
sh1['A2'].value = 'Python'
sh1['B2'].value = 'Avtive'
sh1['C1'].value = row
sh1['C'+str(row)].value = 'test'

for a in range(5):
    sh1['A'+str(a+1)].value = a

wb.save("FinalReport.xlsx")

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