合并CSV文件后并插入到指定excel表某行某列

import os
import pandas as pd
from openpyxl.styles import Border, Side, Alignment, Font
from openpyxl import load_workbook
import openpyxl
import numpy as np

alignment = Alignment(
    horizontal='center',
    vertical='center'
)
border = Border(
    left=Side(border_style="thin", color="000000"),
    right=Side(border_style="thin", color="000000"),
    top=Side(border_style="thin", color="000000"),
    bottom=Side(border_style="thin", color="000000"),
)


def writer_trafico(node, com, lte_df, sheet, is_disbled=False):
    for i in range(0, lte_df.shape[0]):
        for j in range(0, lte_df.shape[1]):
            v = lte_df.iloc[(i, j)]
            sheet.cell(i + node, j + com + 1).value = v
            if is_disbled:
                sheet.cell(i + node, j + com + 1).border = border
            sheet.cell(i + node, j + com + 1).alignment = alignment
            sheet.cell(i + node, j + com + 1).font = Font(name='等线', sz=11)


def find_csv():
    # 找寻当前文件夹内，后缀为.csv的文件
    path_list = [x for x in os.listdir('.')
                 if os.path.isfile(x) and os.path.splitext(x)[1] == '.csv']
    return path_list


if __name__ == '__main__':
    csvpath_list = find_csv()
    data = pd.DataFrame()
    for csv_file in csvpath_list:
        df = pd.read_csv(csv_file, encoding='ANSI')
        Region = csv_file.replace('Trafficzero_', '').replace('.csv', '')
        if len(Region) > 2:
            Region = Region[:-1]
        df['Region'] = Region
        com_list = df.columns.to_list()
        region = com_list.pop(-1)
        com_list.insert(0, region)
        df = df.reindex(columns=com_list)
        # print(data.index)
        # data.insert(0, data.pop(data.index('Region')))
        data = pd.concat([data, df])
    wb = load_workbook(rf'C:\Pycharmproject\OKOK\BBB\data_Traffic_0722.xlsx')
    sh_name = wb.sheetnames
    sh_sh1 = wb[sh_name[1]]
    print(sh_name)
    writer_trafico(2, 7, data, sh_sh1)
    wb.save(rf'C:\Pycharmproject\OKOK\BBB\data_Traffic_0722.xlsx')
# data.columns=data.columns.astype(str)
# print(data.dtypes)
# data.to_csv('aa.csv',index = False,encoding='utf-8-sig')