python完整复制excel模板_python带格式复制Excel和带格式写入

# -*- 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.get_sheet(0)

s.set_name(dj)

font = xlwt.Font()<