border.bottom = border.THIN
font = Font()
font.bold = True
alignment = Alignment()
alignment.horz = alignment.HORZ_CENTER
pattern = Pattern()
pattern.pattern = pattern.SOLID_PATTERN
pattern.pattern_fore_colour = 0x35
title_style.borders = border
title_style.font = font
title_style.alignment = alignment
title_style.pattern = pattern
for i in range(len(title)):
sheet.write(4, i + 4, title[i], title_style)
content = [[1, 'SMITH', '测试', '蔡昶', '2020-10-10'],
[2, '凤姐', '开发', '蔡昶', '2020-10-11']]
content_style = XFStyle()
border = Borders()
border.left = border.THIN
border.right = border.THIN
border.top = border.THIN
border.bottom = border.THIN
content_style.borders = border
