Oh Snap!

Please turnoff your ad blocking mode for viewing your site content

Hit enter after type your search item

Python 3 Script to Write Excel File Using xlwt Module Full Project For Beginners

/
/
/
313 Views

 

Welcome folks today in this post we will be writing excel file using xlwt module. All the source code of the application is given below.

 

 

 

Installation

 

 

In order to install xlwt module we need to install by pip command

 

pip install xlwt

 

 

Now make a app.py file and copy paste the following code

 

 

app.py

 

 

# Writing to an excel 
# sheet using Python 
import xlwt 
from xlwt import Workbook 

# Workbook is created 
wb = Workbook() 

# add_sheet is used to create sheet. 
sheet1 = wb.add_sheet('Sheet 1') 

sheet1.write(1, 0, 'ISBT DEHRADUN') 
sheet1.write(2, 0, 'SHASTRADHARA') 
sheet1.write(3, 0, 'CLEMEN TOWN') 
sheet1.write(4, 0, 'RAJPUR ROAD') 
sheet1.write(5, 0, 'CLOCK TOWER') 
sheet1.write(0, 1, 'ISBT DEHRADUN') 
sheet1.write(0, 2, 'SHASTRADHARA') 
sheet1.write(0, 3, 'CLEMEN TOWN') 
sheet1.write(0, 4, 'RAJPUR ROAD') 
sheet1.write(0, 5, 'CLOCK TOWER') 

wb.save('xlwt example.xls')

 

 

 

READ  Python 3 Script to Find Factorial of a Number Full Tutorial For Beginners

 

 

 

 

Changing Fonts

 

 

# importing xlwt module 
import xlwt 

workbook = xlwt.Workbook() 

sheet = workbook.add_sheet("Sheet Name") 

# Specifying style 
style = xlwt.easyxf('font: bold 1') 

# Specifying column 
sheet.write(0, 0, 'SAMPLE', style) 
workbook.save("sample.xls")

 

 

Changing Color of Cells

 

 

# importing xlwt module 
import xlwt 

workbook = xlwt.Workbook() 

sheet = workbook.add_sheet("Sheet Name") 

# Applying multiple styles 
style = xlwt.easyxf('font: bold 1, color red;') 

# Writing on specified sheet 
sheet.write(0, 0, 'SAMPLE', style) 

workbook.save("sample.xls")

 

 

Leave a Comment

Your email address will not be published. Required fields are marked *

This div height required for enabling the sticky sidebar
Coding Shiksha 2020. All Rights Reserved.
Ad Clicks : Ad Views : Ad Clicks : Ad Views : Ad Clicks : Ad Views : Ad Clicks : Ad Views : Ad Clicks : Ad Views : Ad Clicks : Ad Views : Ad Clicks : Ad Views : Ad Clicks : Ad Views : Ad Clicks : Ad Views : Ad Clicks : Ad Views : Ad Clicks : Ad Views : Ad Clicks : Ad Views :