import os
import openpyxl
def transform(parent_path,out_path):
FileNames = os.listdir(parent_path) #文件夹下面所有的文件
for file in FileNames:
filename=os.path.join(parent_path,file)
wb = openpyxl.load_workbook(filename)
sheet = wb['分省年度数据']
value_name=sheet['A2'].value[3:]
outfile=os.path.join(out_path,value_name)
sheet.delete_rows(36,2)
sheet.delete_rows(1,3)
wb.save(outfile + '.xlsx')
if __name__=='__main__':
path1=r"C:\Users\nuonu\Desktop\province_xlsx" #待转换文件所在目录
path2=r"C:\Users\nuonu\Desktop\province_time" #转换文件存放目录
transform(path1, path2)
运行上面代码时提示Errno 2] No such file or directory:;可自己核对发现该文件夹确确实实创建了呀
为了核对,简化之后,找一个示例结果却是可以输出的
import os
import openpyxl
path2=r"C:\Users\nuonu\Desktop\province_time"
wb = openpyxl.load_workbook("C:\\Users\\nuonu\\Desktop\\bgf.xlsx")
sheet = wb['分省年度数据']
value_name=sheet['A2'].value[3:]
outfile=os.path.join(path2,value_name)
sheet.delete_rows(36,2)
sheet.delete_rows(1,3)
wb.save(outfile+ '.xlsx')
新手上路,还请高人指点