一、xlrd读Excel文件
import xlrd
data = xlrd.open_workbook('D:\性能测试\excel\方言发音测试结果汇总_20201031.xlsx')
'''1、获取工作表 '''
table1 = data.sheets()[0]
table2 = data.sheet_by_index(1)
table3 = data.sheet_by_name(u'河南话')
'''2、获取行数+列数+整行和整列的值 '''
nrows = table1.nrows
ncols = table1.ncols
row = table1.row_values(0)
col = table2.col_values(1)
'''3、获取单元格的值'''
cell_A1 = table1.cell(0,0).value
cell_C4 = table1.cell(3,2).value
二、xlwt写Excel文件
import xlwt
file = xlwt.Workbook()
table = file.add_sheet('info', cell_overwrite_ok=True)
table.write(0, 0, 'wangpeng')
file.save('file.xls')