python excel表格不同sheet计算_Python将excel文件的不同工作表另存为单独的excel文件...

我刚刚解决了这个问题，所以将张贴我的解决方案，我不知道它将如何影响图表等import os

import xlrd

from xlutils.copy import copy

import xlwt

path = #place path where files to split up are

targetdir = (path + "New_Files/") #where you want your new files

if not os.path.exists(targetdir): #makes your new directory

os.makedirs(targetdir)

for root,dir,files in os.walk(path, topdown=False): #all the files you want to split

xlsfiles=[f for f in files] #can add selection condition here

for f in xlsfiles:

wb = xlrd.open_workbook(os.path.join(root, f), on_demand=True)

for sheet in wb.sheets(): #cycles through each sheet in each workbook

newwb = copy(wb) #makes a temp copy of that book

newwb._Workbook__worksheets = [ worksheet for worksheet in newwb._Workbook__worksheets if worksheet.name == sheet.name ]

#brute force, but strips away all other sheets apart from the sheet being looked at

newwb.save(targetdir + f.strip(".xls") + sheet.name + ".xls")

#saves each sheet as the original file name plus the sheet name

不是特别优雅，但很适合我，功能简单。希望对某人有用。在