检索同一文件夹中所有excel文件所包含的sheet名称

import os

import openpyxl

from openpyxl import load_workbook

 

def getFileNames(path):

    filenames = os.listdir(path)

    sFileName=[]

    for i, filename in enumerate(filenames):

        if i==0:

            iSpecialFile=i+1

            sFileName = filename

        getSheetNames(path,filename)

    

def getSheetNames(path,sFileName):

    wb = openpyxl.load_workbook(path+'\\'+sFileName)

    # 获取workbook中所有的表格

    sheets = wb.sheetnames

    # 循环遍历所有sheet

    for i in range (len(sheets)):

        sheet = wb[sheets[i]]

        print(sFileName+'第' + str(i + 1) + '个sheet Name: ' + sheet.title)

        

if __name__=='__main__':

    path = r'……'#修改项

    getFileNames(path)

    print('文件夹内excel检索完毕')