H_xiang_xiang的博客

批量修改一个文件夹下的Excel文件的指定行或列，这个只能修改后缀名为.xlsx的文件。from openpyxl import *import ospath = "存放Excel文件的文件夹路径"filenames = os.listdir(path)for filename in filenames: print(filename) single_path=path+"\\"+filename wb = load_workbook(single_path) w

可以实现功能，转换后的文件可能有字体被加粗之类的问题，转换后需要检查一下。csv_xlsx.pyimport osimport pandas as pddef csv_to_excel(readpath,savepath): for dirpath,dirnames,filenames in os.walk(readpath): for filename in filenames: (purefilename, extension) = os.path.splitext(filena