write in a excel file python 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')