2021-07-19 把一个excel中的sheet页的数据复制到指定的excelsheet页中

import time
import openpyxl
import xlrd
from openpyxl import load_workbook
import os
import warnings
warnings.filterwarnings("ignore")
def print_hi(c_name):
    try:
        xh = ''
        excel = xlrd.open_workbook(r"C:\Users\jiawa\Desktop\Company.xlsx")
        sht = excel.sheets()[0]
        row = sht.nrows
        exe = []
        for i in range(row):
            rowdate = sht.row_values(i)
            exe.append(rowdate)
        for i in exe:
            name = i[2]
            if c_name == name:
                xh = i[1]
        return xh
    except:
        pass


def com_name(name):
    try:
        file_path = r'C:\Users\jiawa\Desktop\Expense.xlsx'
        time.sleep(4)
        xls = openpyxl.load_workbook(file_path)
        sheet_names = xls.sheetnames
        x = print_hi(name).split(" ")[0]
        print(sheet_names)
        for i in  sheet_names:
            if x in i and i.endswith('Journal'):
                print(i)
                return i
    except:
        pass

def copy_excel2(name):
    try:
        path = r"C:\Users\jiawa\Desktop\credentials"
        files = os.listdir(path)
        excel_path = r'C:\Users\jiawa\Desktop\Expense.xlsx'
        for i in files:
            try:
                i = i.split('$')[1]
            except:
                pass
            if name in i:
                path1 = path + "\\" + i
                src_wb = load_workbook(path1)
                dest_wb = load_workbook(excel_path)
                src_sheet = src_wb['Sheet1']
                sheet = com_name(name)
                print(sheet)
                dest_sheet = dest_wb[sheet]
                for i in range(1, src_sheet.max_row + 1):
                    for j in range(1, src_sheet.max_column + 1):
                        dest_sheet.cell(row=i, column=j).value = src_sheet.cell(row=i, column=j).value
                src_wb.save(path1)
                dest_wb.save(excel_path)
    except:
        pass