Answers for "how to write to excel using 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 to write to excel using 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#