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