pandas操作excel

 conda安装pandas

conda install pandas

 如下测试pandas进行获取sheetName、读取excel、修改excel

import pandas as pd
from pandas import DataFrame

def readfileExcel(filepath):
    data = pd.read_excel(filepath)
    #list = data['网址']
    return data
def modifyExcel(filepath,data,sheetName):
    DataFrame(data).to_excel(filepath,sheet_name=sheetName,index=False, header=True)
    pass
def getFirstSheetName(filepath):
    data = pd.read_excel(filepath, sheet_name=None)
    return list(data)[0]

if __name__ == '__main__':
    filepath = "../doc/test.xlsx"
    data = readfileExcel(filepath)
    print(data)

 测试结果如下：

if __name__ == '__main__':
    data['    新增路径'] = listpath
    sheetName = getFirstSheetName(filepath)
    modifyExcel(filepath,data,sheetName)