Python 读写excel

安装模块的方法：pip install xlrd

__author__ = 'Administrator'import xlrd,os,xlwtdef open_excel(filename):    data=xlrd.open_workbook(filename)    return datadef getTableByIndex(filename,index=0):    data=open_excel(filename)    table=data.sheet_by_index(0)        #data.sheet_by_name("")    #table=data.sheets()[index]    colsName=table.row_values(0)    rowNum=table.nrows    colNum=table.ncols    list=[]    for i in range(1,rowNum):        row=table.row_values(i)        dic={}        for j in range(0,colNum):            dic[colsName[j]]=row[j]        list.append(dic)    return listdef writeTable(li,filename,index=0):    file=xlwt.Workbook()    table = file.add_sheet('info',cell_overwrite_ok=True)    #写入数据table.write(行,列,value)    a=list(li[0].keys())    for i in range(0,len(li)):        for j in range(0,len(li[i])):            table.write(i,j,li[i][a[j]])    file.save(filename)def main():    table=getTableByIndex("C:/Users/Administrator/Desktop/计算机学院2017级博士生拟录取名单.xlsx",index=0)    writeTable(table,"C:/Users/Administrator/Desktop/名单.xlsx",index=0)    print(table)if __name__=="__main__":    main()