[python]代码库 data = xlrd.open_workbook(r "D:/people.xlsx" ) |
table = data.sheet_by_name(r "Sheet1" ) |
title = table.row_values( 0 ) |
for h in range ( 1 , nrows): |
values = table.row_values(h) |
people.append( dict ( zip (title, values))) |
workbook = xlwt.Workbook(encoding = 'utf-8' ) |
worksheet = workbook.add_sheet( 'My Worksheet' ) |
style = xlwt.XFStyle() # 初始化样式 |
font1 = xlwt.Font() # 为样式创建字体 |
font2 = xlwt.Font() # 为样式创建字体 |
alignment = xlwt.Alignment() # 设置单元格对齐方式 |
alignment.horz = 0x02 # 0x01(左端对齐)、0x02(水平方向上居中对齐)、0x03(右端对齐) |
alignment.vert = 0x01 # 0x00(上端对齐)、 0x01(垂直方向上居中对齐)、0x02(底端对齐) |
worksheet.col( 0 ).width = 256 * 40 |
worksheet.col( 1 ).width = 256 * 12 |
worksheet.col( 2 ).width = 256 * 16 |
worksheet.col( 3 ).width = 256 * 16 |
worksheet.col( 4 ).width = 256 * 16 |
style.alignment = alignment |
worksheet.write_merge( 0 , 0 , 0 , 4 , '编制人员报表' , style) # 带格式合并单元格写入,0行0列到0行4列合并 |
worksheet.write( 1 , 0 , '单位' , style) # 带样式的写入 |
worksheet.write( 1 , 1 , '姓名' , style) |
worksheet.write( 1 , 2 , '职务' , style) |
worksheet.write( 1 , 3 , '工龄' , style) |
worksheet.write( 1 , 4 , '本年度月份' , style) |
worksheet.write(wl, 0 ,peop[ '主管部门' ],style) |
worksheet.write(wl, 1 , peop[ '姓名' ], style) |
worksheet.write(wl, 2 , peop[ '领导职务层次' ], style) |
worksheet.write(wl, 3 , peop[ '参加工作时间' ], style) |
worksheet.write(wl, 4 , peop[ '进入本单位时间' ], style) |
workbook.save(r 'D:/test.xls' ) # 保存文件 |
if __name__ = = '__main__' : |
from xlutils.copy import copy |
data = xlrd.open_workbook(r "C:\Users\Administrator\Desktop\test.xlsx" ) |
table = data.sheet_by_name(r "Sheet1" ) |
title = table.row_values( 1 ) |
for h in range ( 2 , nrows): |
values = table.row_values(h) |
people.append( dict ( zip (title, values))) |
worksheet = newb.add_sheet( '修改后' ) |
style = xlwt.XFStyle() # 初始化样式 |
font1 = xlwt.Font() # 为样式创建字体 |
worksheet.write( 1 , 0 , '姓名' , style) # 带样式的写入 |
worksheet.write( 1 , 1 , '数据' , style) |
worksheet.write( 1 , 2 , '电话' , style) |
data_t = data_t + "、" + peop[ '数据' ] |
worksheet.write(wl, 0 , name_t, style) |
worksheet.write(wl, 1 , data_t, style) |
worksheet.write(wl, 2 , phone_t, style) |
worksheet.write(wl, 0 , name_t, style) |
worksheet.write(wl, 1 , data_t, style) |
worksheet.write(wl, 2 , phone_t, style) |
newb.save(r 'C:\Users\Administrator\Desktop\test.xlsx' ) |
if __name__ = = '__main__' : |
|