- 批量处理目录下的文件多个csv转换成xls
import pandas as pd
def csv_to_xlsx_pd(csv_pt, encoding='utf-8'):
csv = pd.read_csv(csv_pt, encoding=encoding)
csv.to_excel(csv_pt.split('.')[0]+'.xlsx', sheet_name='data')
# TODO 批量处理目录下的文件 os.listdir
if __name__ == '__main__':
csv_to_xlsx_pd()
Python之xlsx文件与csv文件相互转换
https://blog.csdn.net/qq_33689414/article/details/78307031
https://blog.csdn.net/JohinieLi/article/details/93728489