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

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"

Code answers related to "Python"

Python Answers by Framework

Django
Flask

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#