Formatting cells in Excel with Python

Question

In Excel, with the help of python, How can I format the cells?

I also want to change the font of many rows to be normal instead of bold.

Answer 1

Try executing the below code:

from xlwt import *

font0 = Font()

font0.bold = False

style0 = XFStyle()

style0.font = font0

wb = Workbook()

ws0 = wb.add_sheet('0')

ws0.write(0, 0, 'myNormalText', style0)

font1 = Font()

font1.bold = True

style1 = XFStyle()

style1.font = font1

ws0.write(0, 1, 'myBoldText', style1)

wb.save('format.xls')

Interested to learn python in detail? Come and join the python online course to gain more knowledge!!