python excel转换csv代码实例

__author__ = 'zxl'import pandas as pdimport osimport xlrdpath = r'/Users/zhangxl/Desktop/'filename = 'zxl.xlsx'data = xlrd.open_workbook(os.path.join(path, filename))sheet_names = data.sheet_names()for sheet in sheet_names[0:]:  df = pd.read_excel(os.path.join(path, filename),            sheet_name=sheet,            header=None,            skiprows=1,            encoding='utf-8')  for i in range(1, df.shape[1] + 1, 2):    df1 = df[i]    df1.fillna('', inplace=True)    df1_str = '|'.join(map(str, df1.to_list()))    with open(os.path.join(path, sheet + '_' + str(i) + '.csv'),         'w',         encoding='utf8') as f:      f.write(df1_str)