import openpyxl
import os
from os.path import join
spreadsheet = openpyxl.Workbook()
final_sheet = spreadsheet.get_sheet_by_name('sheet1')
x = 0
for(dir, dirs, files) in os.walk('C:\Users\Cheyn Shmuel\Documents'):
for file in files:
filename = join(dir, file)
try:
workbook = openpyxl.load_workbook(filename)
except:
continue # in case there are files that aren't excel in that directory
for s in workbook.get_sheet_names():
sheet = workbook.get_sheet_by_name(s)
for row in sheet.rows:
for cell in row:
try:
final_sheet[cell.coordinate[0] + str(int(cell.coordinate[1:]) + x)] = cell.value
except:
final_sheet[cell.coordinate[:1] + str(int(cell.coordinate[2:]) + x)] = cell.value
x += sheet.get_highest_row()
spreadsheet.save('your file.xlsx')
Python提供了许多模块。我建议使用
openpyxl
模块。你可以看看here。如果我理解正确,您需要合并多个excel电子表格。我的方法是为所有excel电子表格中的每一行添加一行到新的电子表格中。为此,我编写了一个简单的程序:这个程序将遍历目录中的所有excel文件,并将它们放入新的电子表格中,然后再放入下一个,依此类推。你知道吗
相关问题 更多 >
编程相关推荐