python完整复制excel模板_python复制和编辑excel

#coding=utf-8

import os

import os.path

import sys

from xlrd import open_workbook

from xlutils.copy import copy

from g315.config import conf

import chardet

import re

p=re.compile(r'(?i){{(.*?)}}')

source_file_mold = os.path.join(conf.APP_DIR, "public/excel/source/module.xls")

target_file_mold = os.path.join(conf.APP_DIR, "public/excel/target/result.xls")

import xlrd

import xlwt

from xlrd import open_workbook,cellnameabs

from xlutils.copy import copy

def copy_xf(rdbook,rdxf):

"""

clone a XFstyle from xlrd XF class,the code is copied from xlutils.copy module

"""

wtxf = xlwt.Style.XFStyle()

#

# number format

#

wtxf.num_format_str = rdbook.format_map[rdxf.format_key].format_str

#

# font

#

wtf = wtxf.font

rdf = rdbook.font_list[rdxf.font_index]

wtf.height = rdf.height

wtf.italic = rdf.italic

wtf.struck_out = rdf.struck_out

wtf.outline = rdf.outline

wtf.shadow = rdf.outline

wtf.colour_index = rdf.colour_index

wtf.bold = rdf.bold #### This attribute is redundant, should be driven by weight

wtf._weight = rdf.weight #### Why "private"?

wtf.escapement = rdf.escapement