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')
Original: https://blog.csdn.net/m0_56276607/article/details/126651792
Author: eweidog
Title: 合并CSV文件后并插入到指定excel表某行某列
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/678743/
转载文章受原作者版权保护。转载请注明原作者出处!