汇总各个学校的出库明细表数，并进行核查查看是否有漏填的情况

汇总各个学校的出库明细表数，并进行核查查看是否有漏填的情况

import os
import xlrd
import xlsxwriter

filePath = r'G:\学校各类明细表'
target_xls = r'G:\所有学校所有出库明细表.xlsx'
target_xls_2 = r'G:\各个学校出库明细表数.xlsx'
files_list = os.listdir(filePath)

data = []
data_2 = []
for files in files_list:
    i = 0
    
    file_list = os.listdir(filePath + '\\' + files)
    for file in file_list:
        if '出库明细' in file and '.xls' in file:
            i += 1
            
            source_path = os.path.join(filePath, files, file)
            wb = xlrd.open_workbook(source_path)
            for sheet in wb.sheets():
                for rownum in range(1, sheet.nrows):
                    a = sheet.row_values(rownum)
                    a.append(files)
                    data.append(a)
                    
    data_2.append([files, i])
    print("*"*10, files, "：", i, "*"*10)
                    
workbook = xlsxwriter.Workbook(target_xls)
worksheet = workbook.add_worksheet()
font = workbook.add_format({"font_size":14})
for i in range(len(data)):
    for j in range(len(data[i])):
        worksheet.write(i, j, data[i][j], font)

workbook.close()
print('所有学校所有出库明细表.xlsx 写入完成！')

workbook_2 = xlsxwriter.Workbook(target_xls_2)
worksheet_2 = workbook_2.add_worksheet()
font = workbook_2.add_format({"font_size":14})
for i in range(len(data_2)):
    for j in range(len(data_2[i])):
        worksheet_2.write(i, j, data_2[i][j], font)

workbook_2.close()
print('各个学校出库明细表数.xlsx 写入完成！')