import os
import pandas as pd
import xlrd
#删除ImportFile下所有文件
CUR_PATH = r'C:\Users\11476\Desktop\account_maintenance\ImportFile'
def del_file(path):
ls = os.listdir(path)
for i in ls:
c_path = os.path.join(path, i)
if os.path.isdir(c_path):
del_file(c_path)
else:
os.remove(c_path)
del_file(CUR_PATH)
def excel2csv(excel_file):
# 打开excel文件
workbook = xlrd.open_workbook(excel_file)
# 获取所有sheet名字
sheet_names = workbook.sheet_names()
for index, worksheet_name in enumerate(sheet_names):
# 遍历每个sheet并用Pandas读取
data_xls = pd.read_excel(excel_file, worksheet_name, index_col=None, dtype=str)
data = data_xls.dropna(how='all')
values = data.values
if values.size ==