CODEWITHSUNDEEP
pythonexcelxlwt
gmanikandan
gmanikandan

Reputation: 475

How to change fontsize in excel using python

I have to create a content with font as Times New Roman and font size as 16.How to create using python script ?

My sample script

import xlwt
workbook = xlwt.Workbook(encoding = 'ascii')
worksheet = workbook.add_sheet('My Worksheet')
font = xlwt.Font() # Create the Font
font.name = 'Times New Roman'
style = xlwt.XFStyle() # Create the Style
style.font = font # Apply the Font to the Style
worksheet.write(0, 0, label = 'Unformatted value')
worksheet.write(1, 0, label = 'Formatted value') # Apply the Style to the Cell
workbook.save('fontxl.xls')

Upvotes: 9

Views: 17471

Answers (4)

Rohit rai
Rohit rai

Reputation: 1

style0 = xlwt.easyxf('font: bold 1,height 260, name Times New Roman, color-index red')

You should be user like if you want font change and color also use may be it will be work on excel

Upvotes: 0

Hamza Salem
Hamza Salem

Reputation: 11

just add this

style = xlwt.easyxf('font: bold 1,height 280;')

Upvotes: 1

Wooble
Wooble

Reputation: 90007

You set the font's height in "twips", which are 1/20 of a point:

font.height = 320 # 16 * 20, for 16 point

Upvotes: 16

Junuxx
Junuxx

Reputation: 14271

Although the comment says that you do, you don't actually apply the style you defined!
Use the style keyword in the write() call:

worksheet.write(1, 0, label = 'Formatted value', style = style) # Apply the Style

Upvotes: 1

Related Questions