Answers for "how write to an excel file when its still open python"

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")
Posted by: Guest on February-13-2021

Code answers related to "how write to an excel file when its still open python"

Python Answers by Framework

Browse Popular Code Answers by Language