import xlrd
import xlwt
import xlutils
import xlutils.copy
将一张表划分为不同专业表
def divide_excel(res_path,obj_paths):
# 源文件表
res_file = xlrd.open_workbook(res_path)
res_sheet = res_file.sheet_by_index(0)#按索引获取第一张表
rows = res_sheet.nrows
cols = res_sheet.ncols
# 获取表格的第一行
res_row0 = res_sheet.row_values(0)
numexcel = len(obj_paths)
# 创建目标文件表
obj_files = []
obj_sheets = []
for i in range(numexcel):
obj_files.append(xlwt.Workbook())
obj_sheets.append(obj_files[i].add_sheet(obj_paths[i], cell_overwrite_ok=True))
for j in range(cols):
obj_sheets[i].write(0, j, res_row0[j])
#拷贝内容
res_row = 1 #res_sheet的行指针
obj_row = [1]*numexcel
while res_row<rows:
major = res_sheet.cell_value(res_row, 1)
for i in range(numexcel):
if obj_paths[i] in major:
for j in range(cols):
obj_sheets[i].write(obj_row[i], j, res_sheet.cell_value(res_row, j))
obj_row[i] = obj_row[i] +1
res_row= res_row+1
for i in range(numexcel):
obj_files[i].save(obj_paths[i] + ".xlsx")
def deal(path):
# 源文件表
res_file = xlrd.open_workbook(path+”.xlsx”)
res_sheet = res_file.sheet_by_index(0)#按索引获取第一张表
rows = res_sheet.nrows
types = []
i = 1
while i