import osimport sysimport pandas as pdimport csv path =

import os
import sys
import pandas as pd
import csv 
path = "C:/Users/Administrator/Desktop/新建文件夹 (4)/新建文件夹/新建文件夹"
file_name_list = os.listdir(path)
for i in range(1,3):
    a=str(file_name_list[i])
    df = pd.read_excel(a, index_col=0)
    df.to_csv(a[1:4]+'.csv',encoding="utf_8_sig")
    with open(a[1:4]+'.csv',newline='',encoding="utf_8_sig") as csv_in_file:
        with open(a[0:4]+'.csv', 'w', newline='') as csv_out_file:
            filereader = csv.reader(csv_in_file)
            filewriter = csv.writer(csv_out_file)
            header_list = ['<ApplicableDevices><Device Manufacture="莫迪康" Category="PLC" Model="Slave" /></ApplicableDevices>']
            filewriter.writerow(header_list)
            for row in filereader:
                filewriter.writerow(row)