将不同文件夹下名称相同的excel合并

怎样实现将不同文件夹下相同名称的excel文件合并到一个excel文件中

https://blog.csdn.net/weixin_47036600/article/details/129400596

• 这个问题的回答你可以参考下: https://ask.csdn.net/questions/7429527
• 这篇博客你也可以参考下：同一文件夹下的excel文件合并成一个总excel
• 除此之外, 这篇博客: 提取excel表格特定列合并到一个excel中中的 1.导入新表 部分也许能够解决你的问题, 你可以仔细阅读以下内容或跳转源博客中阅读:
  

• 第一步准备先试试把一个表格的内容全部导入新的表格中，相当于全部复制粘贴。

  lines = open('表格名称.csv','r',encoding='gbk').readlines()
  n = '' 
  for line in lines:
      n = n+line
  with open('new form 1.csv','w',encoding='gbk') as new_f:
      new_f.write(n)
  new_f.close()
  

  第一步成功

• 您还可以看一下 李发展老师的手把手学习Excel电子表格课程中的 如何在Excel自选图形中显示公式的数值小节, 巩固相关知识点
  

可以用Spire.XLS for Python，下面代码里是文件名，你写成完整路径就行

from spire.xls import *
from spire.common import *

#Create a list of file paths for the Excel files to be merged
files = []
files.append("File-1.xlsx" )
files.append("File-2.xlsx")
files.append("File-3.xlsx")

#Create a new workbook
newbook = Workbook()
newbook.Version = ExcelVersion.Version2013
#Clear all default worksheets
newbook.Worksheets.Clear()

#Create a temporary workbook
tempbook = Workbook()

#Iterate through each file in the list of file paths
for file in files:
    #Load the file into the temporary workbook
    tempbook.LoadFromFile(file)
    #Iterate through each worksheet in the temporary workbook
    for sheet in tempbook.Worksheets:
        #Copy the worksheet from the temporary workbook to the new workbook
        newbook.Worksheets.AddCopy(sheet, WorksheetCopyType.CopyAll)

outputFile = "MergeExcelFiles.xlsx"        
#Save the merged file to a specific location
newbook.SaveToFile(outputFile, ExcelVersion.Version2013)
newbook.Dispose()
tempbook.Dispose()

具体可以参考这篇文章（要梯子）