python批量更改文件名

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)