python制作excel分表（按照某一列分类拆分）（一）_load workbook按列分组生辰xlsx

一、按某一列分类拆分成sheet文件

#!/usr/bin/env python
# -*- coding: UTF-8 -*-
#-*-coding:gb2312 -*-
import sys
reload(sys)
sys.setdefaultencoding('utf8')
 
 
from openpyxl import load_workbook
import pandas as pd
import numpy as np
IO='C:\\Users\\23898\\Desktop\\1.xlsx'
 
def _excelAddSheet(dataframe,excelWriter,sheet_name):
       book = load_workbook(excelWriter.path)
       excelWriter.book = book
       dataframe.to_excel(excel_writer=excelWriter,sheet_name=sheet_name,index=None)
       excelWriter.close()
 
 
 
if __name__ == '__main__':
    df=pd.read_excel(IO)
    writer = pd.ExcelWriter(IO)
    excelWriter = pd.ExcelWriter(IO,engine='openpyxl')
    data=df.ix[:,['部门(栏目)']].values#读所有行的title以及data列的值，这里需要嵌套列表
   
 
    DepartmentList=[]
    for department in data:
        if department in DepartmentList:
            # print(department)
            pass
        elif department[0]