import os
from sys import path
import openpyxl
path = 'E:/'
fileList = os.listdir(path)
n = 0
#读取excel文件
wb = openpyxl.load_workbook("./wen2.xlsx")
# 根据sheet名称选取
ws = wb['Sheet1']
row = ws.max_row
column = ws.max_column
data=[]
for c in range(row):
b1 = list(ws.rows)[c][0].value
data.append(b1)
#遍历,并转换成字符串
for i in range(0,len(data)):
oldname = path + os.sep + fileList[i] # os.sep添加系统分隔符
newname = path + os.sep + str(data[i]) + '.pdf'
os.rename(oldname, newname) # 用os模块中的rename方法对文件改名
print(oldname, '======>', newname)