Python强化知识之xlwt（三）

xlwt 是 Python 用来在 Excel 写入数据和格式化数据的工具包

# 0.导入xlst模块
import xlwt# 1.创建 Workbook
wb &＃61; xlwt.Workbook()# 2.创建 worksheet
ws &＃61; wb.add_sheet(&＃39;test_sheet&＃39;)# 3.写入第一行内容 ws.write(a, b, c) a&＃xff1a;行&＃xff0c;b&＃xff1a;列&＃xff0c;c&＃xff1a;内容
ws.write(0, 0, &＃39;球队&＃39;)
ws.write(0, 1, &＃39;号码&＃39;)
ws.write(0, 2, &＃39;姓名&＃39;)
ws.write(0, 3, &＃39;位置&＃39;)# 保存文件
wb.save(&＃39;./myExcel.xls&＃39;)

Font()

属性&＃xff1a;

font.name &＃61; &＃39;Times New Roman&＃39;
font.bold &＃61; True # 黑体
font.underline &＃61; True # 下划线
font.italic &＃61; True # 斜体字
font &＃61; xlwt.Font() # 为样式创建字体
font.name &＃61; &＃39;Times New Roman&＃39;
font.bold &＃61; True # 黑体
font.underline &＃61; True # 下划线
font.italic &＃61; True # 斜体字

Style()

def set_style(name, height, bold&＃61;False, format_str&＃61;&＃39;&＃39;,align&＃61;&＃39;center&＃39;):style &＃61; xlwt.XFStyle() # 初始化样式font &＃61; xlwt.Font() # 为样式创建字体font.name &＃61; name # &＃39;Times New Roman&＃39;font.bold &＃61; boldfont.height &＃61; heightborders &＃61; xlwt.Borders() # 为样式创建边框borders.left &＃61; 2borders.right &＃61; 2borders.top &＃61; 0borders.bottom &＃61; 2alignment &＃61; xlwt.Alignment() # 设置排列if align&＃61;&＃61; &＃39;center&＃39;:alignment.horz &＃61; xlwt.Alignment.HORZ_CENTERalignment.vert &＃61; xlwt.Alignment.VERT_CENTERelse:alignment.horz &＃61; xlwt.Alignment.HORZ_LEFTalignment.vert &＃61; xlwt.Alignment.VERT_BOTTOMstyle.font &＃61; fontstyle.borders &＃61; bordersstyle.num_format_str &＃61; format_strstyle.alignment &＃61; alignmentreturn style

合并

worksheet.write_merge(0, 0, 0, 3, &＃39;First Merge&＃39;) # Merges row 0&＃39;s columns 0 through 3.
worksheet.write_merge(1, 2, 0, 3, &＃39;Second Merge&＃39;, style)

对齐

import xlwt
workbook &＃61; xlwt.Workbook()
worksheet &＃61; workbook.add_sheet(&＃39;My Sheet&＃39;)
alignment &＃61; xlwt.Alignment() # Create Alignment
alignment.horz &＃61; xlwt.Alignment.HORZ_CENTER # May be: HORZ_GENERAL, HORZ_LEFT, HORZ_CENTER, HORZ_RIGHT, HORZ_FILLED, HORZ_JUSTIFIED, HORZ_CENTER_ACROSS_SEL, HORZ_DISTRIBUTED
alignment.vert &＃61; xlwt.Alignment.VERT_CENTER # May be: VERT_TOP, VERT_CENTER, VERT_BOTTOM, VERT_JUSTIFIED, VERT_DISTRIBUTED
style &＃61; xlwt.XFStyle() # Create Style
style.alignment &＃61; alignment # Add Alignment to Style
worksheet.write(0, 0, &＃39;Cell Contents&＃39;, style)
workbook.save(&＃39;Excel_Workbook.xls&＃39;)

背景色

import xlwt
workbook &＃61; xlwt.Workbook()
worksheet &＃61; workbook.add_sheet(&＃39;My Sheet&＃39;)
pattern &＃61; xlwt.Pattern() # Create the Pattern
pattern.pattern &＃61; xlwt.Pattern.SOLID_PATTERN # May be: NO_PATTERN, SOLID_PATTERN, or 0x00 through 0x12
pattern.pattern_fore_colour &＃61; 5 # May be: 8 through 63. 0 &＃61; Black, 1 &＃61; White, 2 &＃61; Red, 3 &＃61; Green, 4 &＃61; Blue, 5 &＃61; Yellow, 6 &＃61; Magenta, 7 &＃61; Cyan, 16 &＃61; Maroon, 17 &＃61; Dark Green, 18 &＃61; Dark Blue, 19 &＃61; Dark Yellow , almost brown), 20 &＃61; Dark Magenta, 21 &＃61; Teal, 22 &＃61; Light Gray, 23 &＃61; Dark Gray, the list goes on...
style &＃61; xlwt.XFStyle() # Create the Pattern
style.pattern &＃61; pattern # Add Pattern to Style
worksheet.write(0, 0, &＃39;Cell Contents&＃39;, style)
workbook.save(&＃39;Excel_Workbook.xls&＃39;)