使用python语句拆分表格
说明:不记得这代码是从那里搬过来的,忘记,
下面直接给出需要拆分表格样本
主要是根据第五列1和2拆分子工作表,下面是核心代码
# -*- coding:utf-8 -*-
from openpyxl import Workbook, load_workbook
from openpyxl.worksheet.table import Table, TableStyleInfo
from openpyxl.styles import Font, colors, Alignment,PatternFill,Protection
from openpyxl.utils import get_column_letter, column_index_from_string
from openpyxl.styles import Side,Border
def caiFenSheet(sheet, c):
ls = []
for row in sheet.values:
ls.append(row)
title = ls[0]
chn = []
ls = ls[1:]
for i in ls:
chn.append(i[c - 1])
chns = list(set(chn))
ls_chns = {}
for i_chns in chns:
new_ls = []
for i_ls in ls:
if i_chns == i_ls[c - 1]:
new_ls.append(i_ls)
ls_ch