python 数据分析基础 day7－xlrd,xlwt读写多个excel通过xlrd和xlwt读多个excel文件并写入一个新excel文件

import pandas as pd
import glob
import os
import xlrd
import xlwt

inputPath=r"读取excel文件的路径"
outputExcel=r"输出的excel文件的具体路径"
outputWorkbook=xlwt.Workbook()
#将读入数据写入变量中
for inputWorkbook in glob.glob(os.path.join(inputPath,"*.xlsx")):
    with xlrd.open_workbook(inputWorkbook) as workbook:
        workbookName=os.path.basename(inputWorkbook)
        firstSheetFlag=1  
        setRow=0
        for sheet in workbook.sheets():
            #为输出工作表添加表头
            if firstSheetFlag:
                outputWorksheet=outputWorkbook.add_sheet(workbookName)
                for cInd in range(sheet.ncols):
                    outputWorksheet.write(0,cInd,sheet.cell_value(0,cInd))
                firstSheetFlag=0
            for rInd in range(1,sheet.nrows):
                for cInd in range(sheet.ncols):
                    outputWorksheet.write(rInd+setRow,cInd,sheet.cell_value(rInd,cInd))
            setRow=setRow+sheet.nrows-1
outputWorkbook.save(outputExcel)