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