excel_copy.py

# -*-coding:utf-8-*-
# __author__ == "DT"
# __date__ == "2019/01/23"


import os, sys, stat
import os.path
import xlrd
# import xlsxwriter
# from openpyxl import Workbook
from xlutils.copy import copy


def copy_sheet(from_xls, to_xls):
    wb = xlrd.open_workbook(from_xls, formatting_info=True)
    from_all_sheet = wb.sheet_names()

    wb1 = xlrd.open_workbook(to_xls)
    to_all_sheet = wb1.sheet_names()

    if "字段说明" in from_all_sheet:
        from_sheet = wb.sheet_by_name("字段说明")
        from_nrows = int(from_sheet.nrows)
        from_ncols = int(from_sheet.ncols)

        if "字段说明" in to_all_sheet:
            print(to_xls + "中已经存在，字段说明")

        else:
            old_to_xls = xlrd.open_workbook(to_xls, formatting_info=True)
            new_to_xls = copy(old_to_xls)
            add_sheet = new_to_xls.add_sheet('字段说明')

            for i in range(from_ncols):

                for n in range(from_nrows):
                    value = from_sheet.cell_value(n, i)
                    print("正在拷贝" + "第%d行" % n + "第%d列" % i + "数据：" + str(value))
                    add_sheet.write(n, i, value)

            new_to_xls.save(to_xls)
            os.chmod(to_src, stat.S_IREAD)
            print("\n数据拷贝完成")

    else:
        print((from_xls.split("\\"))[-1] + " 中没有'字段说明'表格")
        pass


if __name__ == '__main__':

    from_path = r'E:\Rose\DRAGONBALL_CHINA\Trunk\branch_DragonBall\Design\ConfigExcel'
    to_path = r'C:\1\excel'
    config_path = r"C:\1\config_xls_name.txt"

    config_file = open(config_path)
    f = config_file.readlines()
    from_list = os.listdir(from_path)
    to_list = os.listdir(to_path)
    for f_name in f:
        f_name = f_name.replace("\n", "")
        if f_name in from_list:
            if f_name in to_list:
                if ".xls" in f_name:
                    from_src = r'%s' % (from_path + "\\" + f_name)
                    to_src = r'%s' % (to_path + "\\" + f_name)

                    # print(f_name, from_src, to_src)
                    os.chmod(to_src, stat.S_IREAD+stat.S_IWRITE)
                    copy_sheet(from_src, to_src)
                else:
                    print(f_name + "文件不是excel文件")
            else:
                print("目标径没有文件: " + f_name)
        else:
            print("源路径没有文件: " + f_name)