Python 读写excel

安装模块的方法：pip install xlrd

__author__ = 'Administrator'
import xlrd,os,xlwt

def open_excel(filename):
    data=xlrd.open_workbook(filename)
    return data

def 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 list

def 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()