Python_xlwt模块介绍

1 import xlwt
2 workbook = xlwt.Workbook(encoding = ‘utf-8‘)
3     # 创建一个workbook并设置编码形式

1 worksheet = workbook.add_sheet(‘My Worksheet‘)
2     # 创建一个worksheet

1 worksheet.write(1,label = ‘this is test‘)
2     # 参数对应 行,列,值
3 
4 workbook.save(‘Excel_test.xls‘)
5     # 保存

 1 import xlwt
 2  
 3 workbook = xlwt.Workbook(encoding = ‘ascii‘)
 4 
 5 worksheet = workbook.add_sheet(‘My Worksheet‘)
 6      # 添加名为My Worksheet的工作表
 7 
 8  style = xlwt.XFStyle() 
 9      # 初始化样式
10 
11 font = xlwt.Font() 
12      # 为样式创建字体
13 
14 font.name = ‘Times New Roman‘
15 
16 font.bold = True 
17      # 黑体
18 
19 font.underline = True 
20     # 下划线
21 
22 font.italic = True 
23     # 斜体字
24 
25 style.font = font 
26     # 设定样式
27 
28 worksheet.write(0,‘Unformatted value‘)     
29     # 不带样式的写入
30 
31 worksheet.write(1,‘Formatted value‘,style) 
32     # 带样式的写入
33 
34 workbook.save(‘formatting.xls‘) 
35     # 保存文件

 1 import xlwt
 2 
 3 workbook = xlwt.Workbook()
 4 worksheet = workbook.add_sheet(‘My Sheet‘)
 5 worksheet.write(0,‘My Cell Contents‘)
 6 
 7 
 8 worksheet.col(0).width = 3333
 9     # 设置单元格宽度
10 worksheet.col(0).height = 3333
11     # 设置单元格宽度
12 
13 workbook.save(‘cell_width.xls‘)