1 # encoding: utf-8
 2 import os
 3 import sys
 4 
 5 import openpyxl
 6 import tkinter as tk
 7 from tkinter import filedialog
 8 import tkinter as tk
 9 from tkinter import filedialog
10 import tkinter.messagebox as msgbox
11 import tkinter as tk, time
12 
13 count = 1
14 def t(pa,expa,she):
15     print(f'\'{pa}\'')
16     print(f'\'{expa}\'')
17     print(f'\'{she}\'')
18     path = f'{pa}'#文件所在文件夾
19     expath =f'{expa}'#名單所在文件夾
20     x1 = openpyxl.load_workbook(expath)#讀取excel
21 
22     sheet1 = x1[f'{she}']#讀取sheet1
23 
24     xwsr = 2#修改
25     filelist = os.listdir(path)#讀取文件目錄
26     for files in filelist:#遍歷文件目錄
27         xr = sheet1.cell(row=xwsr, column=3)#可變
28         xc = sheet1.cell(row=xwsr, column=4)#可變
29         #可填加
30         Olddir = os.path.join(path,files)#舊的文件位置
31         #os.renames(Olddir,os.path.join(path,str(xylist[count]+".jpg"))#新的文件位置
32         os.rename(Olddir,os.path.join(path,str(xr.value+xc.value)+".jpeg")) #str里可加
33         xwsr = xwsr+1
34     filelist1 = os.listdir(path)#讀取文件目錄
35     filelist1.sort()
36     sys.exit()
37 def xuan():
38     '''打開選擇文件夾對話框'''
39     root = tk.Tk()
40     root.withdraw()
41     msgbox.showinfo('提示','選擇要修改命名的圖片的存放文件夾')
42     Folderpath = filedialog.askdirectory() #獲得選擇好的文件夾
43     msgbox.showinfo('提示','選擇要騰訊表格')
44     Filepath = filedialog.askopenfilename() #獲得選擇好的文件
45     msgbox.showinfo('提示','輸入sheet1的內容')
46     window = tk.Tk()
47     window.title("輸入")
48     e = tk.Entry(window)
49     e.pack()
50     def get():
51         str =e.get()
52         print(f'\'{Folderpath}\'')
53         print('Folderpath:', Folderpath)
54         print('Folderpath:', Filepath)
55         window.destroy()
56         root.destroy()
57         t(Folderpath,Filepath,str)
58     b = tk.Button(window, text="確認", command=get)
59     b.pack()
60     window.mainloop()
61 xuan()