特牛生活网

Python之xlsx文件与csv文件相互转换_def xlsx_to_csv(): workbook = xlrd.open_workbook('-CSDN博客

网友收藏
文章浏览阅读1.3w次,点赞56次,收藏108次。Python之xlsx文件与csv文件相互转换在Python中,可以使用xlrd和csv模块来处理Excel文件和csv文件。xlsx文件转csv文件import xlrdimport csvdef xlsx_to_csv(): workbook = xlrd.open_workbook('1.xlsx') table = workbook.sheet_by_index(0) with codecs.open('1.csv', 'w', encoding='utf-8')_def xlsx_to_csv(): workbook = xlrd.open_workbook('swat_dataset_normal_v1.xls