Skip to content
TheChatArchiveThe Chat Archive
gpt-4-0314· openaiHugging Face Suzhen/CodeChat

写一段Python,用tkinter: 1,输入手机号,选择指定文件夹,从文件夹下的EXcel文件查找信息并输出

  1. User

    写一段Python,用tkinter: 1,输入手机号,选择指定文件夹,从文件夹下的EXcel文件查找信息并输出

  2. Assistant
    import tkinter as tk
    from tkinter import ttk
    from tkinter import filedialog
    import os
    import pandas as pd
    
    def browse_folder():
        folder = filedialog.askdirectory()
        folder_path.set(folder)
    
    def find_info():
        folder = folder_path.get()
        phone_number = entry_phone.get()
    
        for file in os.listdir(folder):
            if file.endswith('.xlsx') or file.endswith('.xls'):
                file_path = os.path.join(folder, file)
                df = pd.read_excel(file_path)
    
                if phone_number in df['Phone'].values:
                    output.set(f"Found in {file}: {df.loc[df['Phone'] == phone_number].to_string()}")
                    return
        
        output.set("Not found")
    
    app = tk.Tk()
    app.title('Phone Number Finder')
    
    label_phone = ttk.Label(app, text="Phone Number:")
    label_phone.grid(column=0, row=0)
    
    entry_phone = ttk.Entry(app)
    entry_phone.grid(column=1, row=0)
    
    label_folder = ttk.Label(app, text="Folder:")
    label_folder.grid(column=0, row=1)
    
    folder_path = tk.StringVar()
    entry_folder = ttk.Entry(app, textvariable=folder_path)
    entry_folder.grid(column=1, row=1)
    
    button_browse = ttk.Button(app, text="Browse", command=browse_folder)
    button_browse.grid(column=2, row=1)
    
    label_output = ttk.Label(app, text="Output:")
    label_output.grid(column=0, row=3)
    
    output = tk.StringVar()
    output.set("Phone number information will be displayed here.")
    label_output = ttk.Label(app, textvariable=output)
    label_output.grid(column=1, row=3, columnspan=2)
    
    button_find = ttk.Button(app, text="Find Info", command=find_info)
    button_find.grid(column=0, row=2, columnspan=3)
    
    app.mainloop()
    

    这段Python代码使用tkinter库创建了一个简单的界面,用户可以输入手机号、选择指定的文件夹,并从文件夹中的Excel文件中查找信息并输出。用户需要确保Excel文件中的手机号码列名为'Phone'。如果找到匹配项,程序会输出该项所在的文件以及条目的详细信息。

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.