Answers for "python write to an open excel file"

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 "python write to an open excel file"

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#