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
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
# 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') |
Changing Fonts
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
# 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
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
# 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") |
