python
import xlwt
workbook = xlwt.Workbook()
style = xlwt.XFStyle()
font = xlwt.Font()
font.name = 'Arial'
font.bold = True
font.color_index = 2
style.font = font
sheet = workbook.add_sheet('Sheet1')
sheet.write(0, 0, 'Hello', style)
workbook.save('styled_excel.xls')
python
import xlwt
workbook = xlwt.Workbook()
sheet = workbook.add_sheet('Sheet1')
sheet.write_merge(0, 0, 0, 1, 'Merged Cell')
workbook.save('merged_excel.xls')
python
import xlwt
workbook = xlwt.Workbook()
sheet = workbook.add_sheet('Sheet1')
format_str = '#,##0.00'
number = 12345.6789
number_style = xlwt.XFStyle()
number_format = xlwt.XFStyle()
number_format.num_format_str = format_str
sheet.write(0, 0, number, number_style)
workbook.save('formatted_excel.xls')
pip install xlwt
pip install xlrd
