1、解析.xls文件
使用 xlrd 库
代码如下：
# XLS_PATH xls 文件路径
workbook = xlrd.open_workbook(XLS_PATH)
data_sheet = workbook.sheets()[0]
rowNum = data_sheet.nrows # sheet行数
colNum = data_sheet.ncols # sheet列数
contacts = []
for i in range(1,rowNum):
dict = {}
for j in range(colNum):
title = data_sheet.cell_value(0, j)
value = data_sheet.cell_value(i, j)
dict[title] = value
contacts.append(dict)
print(contacts) //字典数组
2、解析.cvs文件
使用 cvs 库
代码如下：
# XLS_PATH 文件路径 model: 打开文件的方式 encoding 编码
with open(XLS_PATH, mode='r', encoding='utf-8') as f:
reader = csv.reader(f)
contacts = []
for row in reader:
if row[0] == 'phone':
continue
dic = {}
dic.update(phone=row[0])
dic.update(remark=row[1])
contacts.append(dic)
return contacts
