01
# -*- coding: utf-8 -*-
import xlwt
import pandas as pd
import numpy as np
from xlrd import open_workbook
from xlutils.copy import copy
data = 'all.xls'
muban = 'muban.xls'
for mon in range( 201501, 201513 ):
allData = pd.read_excel( data, sheetname = str( mon ), skiprows = [ 0, 1 ] )
allData = allData.iloc[ : -2, : 10 ] # 除去表头表尾
allData.sort_values( by = [ '单据号码', '物料编码' ], inplace = True )
for dj in allData[ '单据号码' ].drop_duplicates():
newFile = dj + '.xls'
thisData = allData[ allData[ '单据号码' ] == dj ]
date = thisData[ '发生日期' ].iloc[ 0 ]
rb = open_workbook(muban,formatting_info=True)
rs = rb.sheet_by_index(0)
wb = copy(rb)
s=wb.ge