python 重命名文件

读取pdf文件
以如下“序號”為依據，將對應序號的PDF檔改名，改後的名稱為excel中對應的“文件名”

代码：

import xlrd
import os
from xlrd import open_workbook

file_dir = os.getcwd()
if not os.path.exists(os.path.join(file_dir, "文件名稱匯總.xlsx")):
    print("File Not Find")
else:
    data = xlrd.open_workbook(os.path.join(file_dir, "文件名稱匯總.xlsx"))
    s = data.sheets()[0]
    rows = s.nrows

    for i in range(1, rows):
        row = s.row_values(i)
        old_file_name = str(int(row[1]))+".pdf"
        print(old_file_name)
        new_file_name = str(row[0])+".pdf"
        print(new_file_name)
        if os.path.exists(os.path.join(file_dir, old_file_name)):
            print("rename file", old_file_name, "to", new_file_name)
            os.rename(old_file_name, new_file_name)