将字典内容打印为字符串并分行的方法
data = {'姓名': '赵军力', '英语': 69, '办公软件操作': 69, '电子商务': 63, '计算机基础': 76}
lst = []
lst1 = ''
for _ in data:
if _ == '姓名':
continue
else:
lst.append('%s:%s分\n' % (_,data[_]))
for i in lst:
lst1 = lst1 + str(i)
print(lst1)
xls文件读操作
import xlrd
wb = xlrd.open_workbook('files/data1.xls')
names = wb.sheet_names()
print(names)
sheet1 = wb.sheet_by_name('students')
print(sheet1)
sheet2 = wb.sheet_by_index(1)
print(sheet2)
print(sheet1.nrows)
print(sheet1.ncols)
result = sheet1.row_values(1)
print(result)
result = sheet1.col_values(3)
print(result)
result= sheet1.row_values(2,0,3)
print(result)
result = sheet1.col_values(1,0,3)
print(result)
data = []
if os.path.exists('files/data1.xls'):
wb = xlrd.open_workbook('files/data1.xls')
else:
print('Error! Unable to find file!')
names = wb.sheet_names()
if 'students' in names:
sheet = wb.sheet_by_name('students')
else:
print('Error! Unable to find file')
row = sheet.nrows
col = sheet.ncols
for _ in range(1, row):
result = sheet.row_values(_, 0, col)
data.append(result)
lst = []
dic = {}
lst1 = []
datas = sheet.row_values(0)
for _ in range(1,row):
lst = sheet.row_values(_, 0,row)
dic = dict(zip(datas,lst))
lst1.append(dic)
print(lst1)
print(data)
xls文件写操作
import xlwt
import os
import xlrd
wb = xlwt.Workbook()
sheet = wb.add_sheet('students')
sheet.write(0,0,'name')
data = [
['小明', '男', 20.0, 99.0],
['张三', '男', 25.0, 87.0],
['小花', '女', 22.0, 95.0],
['老王', '男', 30.0, 77.0]
]
if os.path.isfile('files/data3.xls'):
wb = xlrd.open_workbook('files/data3.xls')
print('----')
names = wb.sheet_names()
if 'students' in names:
sheet2 = wb.sheet_by_name('students')
else:
sheet2 = wb.add_sheet('students')
else:
wb = xlwt.Workbook()
sheet2 = wb.add_sheet('students')
print('***')
sheet2.write(0, 0, 'name')
sheet2.write(0, 1, 'gender')
sheet2.write(0, 2, 'age')
sheet2.write(0, 3,'score')
for _ in range(1,len(data)+1):
col = 0
for i in data[_-1]:
sheet2.write(_,col,i)
col += 1
wb.save('files/data3.xls')
文件设置单元格样式
import xlwt
wb = xlwt.Workbook()
sheet = wb.add_sheet('各种样式')
sheet.write(0,0,'香蕉')
style1 = xlwt.XFStyle()
font1 = xlwt.Font()
pattern1 = xlwt.Pattern()
style1.font = font1
style1.pattern = pattern1
print(xlwt.Style.colour_map)
font1.name = '宋体'
font1.height = 20*20
font1.colour_index = 28
font1.bold = True
font1.italic = True
pattern1.pattern = xlwt.Pattern.SOLID_PATTERN
pattern1.pattern_fore_colour = 52
sheet.col(0).width = 50*256
sheet.row(2).height = True
sheet.row(2).height = 40*60
sheet.write(1,0,'苹果',style1)
wb.save('files/data4.xls')