数据分析——Excel文件

1、创建并写入xls文件

import xlwt import Workbook
book = Workbook(os.path.dirname(__file__) + '\\defects.xls')
sheet = book.add_sheet('defects')
for i in range(len(names_dict)):
    sheet.write(i,0,list(names_dict.keys())[i]) #将字典keys值写入第0列
    sheet.write(i,1,list(names_dict.values())[i]) #将字典values值写入第1列
book.save(os.path.dirname(__file__) + '\\defects.xls')

2、写入xls文件

from xlrd import open_workbook
from xlutils.copy import copy
rb=open_workbook('D:\\judge.xls') #没有文件则报错
wb=copy(rb)
ws=wb.get_sheet('judge')
ws.write(0,0,'judge')
wb.save('D:\\judge.xls')

3、读取xls文件

from xlrd import open_workbook
book = open_workbook('D:\\judge.xls') #没有文件则报错
sheet = book.sheet_by_name('judge')
value = sheet.cell_value(0, 0)
os.path.exists('D:\\judge.xls')  #用于判断文件是否存在