xlwt操作:
# -*- coding:UTF-8 -*-
import xlwt
file = xlwt.Workbook()
table = file.add_sheet('sheet name') # 新建一个sheet
# table.write(0, 0, 'test') # 写入数据table.write(行,列,value)
for i in range(0, 10):
for j in range(0, 2):
table.write(i, j, i*j) # 写入行列
table = file.add_sheet('sheet nam', cell_overwrite_ok=True)
file.save('d.xls')
# 使用style
style = xlwt.XFStyle()
font = xlwt.Font()
font.name = 'Time New Roman'
font.bold = True
style.font = font
table.write(0, 0, 'some bold Times text', style)