python xlsx转换csv 并自动创建csv文件且替换csv分隔符

置顶

python小小小小白菜

已于 2023-01-17 14:52:01 修改

阅读量369

点赞数

CC 4.0 BY-SA版权

分类专栏：学习总结文章标签： python

于 2023-01-06 14:08:02 首次发布

本文链接：https://blog.youkuaiyun.com/weixin_41072741/article/details/128577738

import pandas as pd
import PySimpleGUI as sg
import os
from pathlib import Path
import csv
import datetime
#import re
def csv_xlsx_file(file_name):
    end_name = os.path.splitext(file_name)[1]
    if end_name == '.txt':
        print(file_name)
    elif end_name == '.csv':
        reader1 = list(csv.reader(open(file_name, "rU", encoding='utf8', errors='ignore'