Python合并同文件夹下面Excel文件并且求和汇总
将程序放到Excel的文件夹下执行即可
import openpyxl,os,xlrd,time
import pandas as pd
import numpy as np
"""wb = openpyxl.load_workbook('200S010A.xlsx')
sheet = wb.get_sheet_by_name('Sheet1')
print(sheet['B1'].value)
b = sheet.max_row
print(b)
#卸载已安装的
pip uninstall xlrd
#下载对应的版本
pip install xlrd==1.2.0"""
file_path = os.getcwd()
pathss=[]
for files in os.listdir(file_path):
path = os.path.join(file_path, files)
pathss.append(path) #添加新元素
data=[]
DD=[]
for i in pathss:
if i != file_path+r'\excel.py':
wb=xlrd.open_workbook(i) #按相应路径读取工作簿
ws=wb.sheet_by_index(0</