将Excel表格xlsx文件转成csv文件

Excel表格一般情况下都有多个表单，每个表单读出来就是一个datafram对象

import os
import pandas as pd

filePath = 'E:\ProjectFile\File_Processing\XLSX\To_csv\data'
files = [i for i in os.listdir(filePath) if 'xlsx' in i ]

for file in files:
    try:
        print(file)
        filenamePath = os.path.join(filePath, file)
        dfs = pd.read_excel(filenamePath, None, index_col=0)
        for types, df in dfs.items():
            Newname = f'{file[:-5]}_{types}.csv'
            NewfilenamePath = os.path.join(filePath, Newname)
            df.to_csv(NewfilenamePath)
    except:
        pass