import tkinter as tk
from tkinter import filedialog
from selenium import webdriver
import time
import pandas as pd
from pyzbar.pyzbar import decode
from PIL import Image
'''打开选择文件夹对话框'''
root = tk.Tk()
root.withdraw()
Folderpath1 = filedialog.askdirectory() #获得选择好的文件夹
Filepath1= filedialog.askopenfilename() #获得选择好的文件
# print('Folderpath1:',Folderpath1)
# print('Filepath1:',Filepath1)
image =(Filepath1)
img = Image.open(image)
barcodes = decode(img)
for barcode in barcodes:
url = barcode.data.decode("utf-8")
# print(url)
Folderpath = filedialog.askdirectory() #获得选择好的文件夹
Filepath = filedialog.askopenfilename() #获得选择好的文件
# print('Folderpath:',Folderpath)
# print('Filepath:',Filepath)
df = pd.read_excel(Filepath, converters={'数量': str})
for idx, row in df.iterrows():
# print(df.head())
profile = webdriver.FirefoxProfile()
profile.set_preference('browser.download.folderList', 2)
profile.set_preference('browser.download.manager.showWhenStarting', False)
profile.set_preference('browser.helperApps.neverAsk.saveToDisk', 'application/x-excel')
driver = webdriver.Firefox(firefox_profile=profile)
driver.get('https://kcm.hualife.cc:8443/emp/agentmenu.php?id=124935&t=1663585080')
time.sleep(0.2)
driver.find_element_by_link_text('领取物资').click()
工号 = row["工号"]
driver.find_element_by_id('empno').send_keys(工号)
time.sleep(0.2)
姓名 = row["姓名"]
driver.find_element_by_id('name').send_keys(姓名)
time.sleep(0.2)
电话 = row["电话"]
driver.find_element_by_id('phone').send_keys(电话)
time.sleep(0.2)
数量 = row["数量"]
driver.find_element_by_id('num').send_keys(数量)
time.sleep(0.2)
driver.find_element_by_id('agt').click() # 点击提交
time.sleep(1)
driver.close()
上面是代码,我想把这个代码做成exe文件,然后给别人用,别人电脑里可能没有库或者web driver ,希望能帮忙做成exe文件,跪谢,做完可以发我邮箱吗 ?362961412@qq.com