实现结果:
import xlwt
book = xlwt.Workbook(encoding='utf-8')
sheet = book.add_sheet('sheet1', cell_overwrite_ok=True)
alignment = xlwt.Alignment()
alignment.horz = 0x02
alignment.vert = 0x01
style0 = xlwt.XFStyle()
style0.alignment = alignment
font = xlwt.Font()
font.height = 20 * 11
font.bold = True
style1 = xlwt.XFStyle()
style1.font = font
style1.alignment = alignment
colarr = ('', 'name', 'age', 'sex')
for i in range(len(colarr)):
sheet.write(0, i, colarr[i], style=style1)
data = [[1, '02-Cc-II-重庆长安寺(佛教会)-001.jpg', '梁思成', 98.6, '莫宗江', 96], [2, '03-Cc-IV-重庆文庙-004.jpg', '陈明达', 92.61]]
maxarr = [0, 0, 0, 0, 0, 0]
for row in range(len(data)):
for col in range(len(colarr)):
val = str(data[row][col])
sheet.write(row + 1, col, val, style=style0)
if len(val) > maxarr[col]:
maxarr[col] = len(val)
for i in range(len(colarr)):
sheet.col(i).width = (maxarr[i] + 8) * 256
for i in range(len(data) + 1):
sheet.row(i).height_mismatch = True
sheet.row(i).height = 400
book.save('result_lwd.xls')