Skip to content
The Chat Archive
gpt-4-0314· OpenAI WildChat-4.8M (AI2)

写一段Python,用tkinter: 1,输入手机号,从后台Excel表格查找,实时显示用户所有信息

  1. User

    写一段Python,用tkinter: 1,输入手机号,从后台Excel表格查找,实时显示用户所有信息

  2. Assistant

    在当前目录中创建一个名为phonebook.xlsx文件,然后在文件中创建一个表格以存储数据。然后在Python文件中使用以下代码。确保安装了pandas & openpyxl模块。 pip install pandas openpyxl.

    from tkinter import *
    import pandas as pd
    
    def search():
        try:
            df = pd.read_excel('phonebook.xlsx')
            phone = entry_phone.get()
            result = df.loc[df['phone'] == int(phone)].to_string(index=False)
            if not result:
                msg = f"No data found for phone number: {phone}."
            else:
                msg = f"Data for phone number: {phone}\n{result}"
            labelText.set(msg)
            entry_phone.delete(0, END)
        except:
            labelText.set("Error occurred!")
    
    
    root = Tk()
    root.title("Phonebook")
    
    frame = Frame(root)
    frame.pack()
    
    label = Label(frame, text="Enter Phone Number:")
    label.grid(row=0, column=0)
    
    entry_phone = Entry(frame)
    entry_phone.grid(row=0, column=1)
    
    button = Button(frame, text="Find", command=search)
    button.grid(row=1, columnspan=2)
    
    labelText = StringVar()
    
    resultsLabel = Label(frame, textvariable=labelText)
    resultsLabel.grid(row=2, columnspan=2)
    
    root.mainloop()
    

    这将在数据表格中查找您提供的手机号,并返回与该手机号码关联的所有信息。DataFrame中的数据按行查找,然后显示在GUI上。

  3. User

    修改一下代码: 1,输入号码直接实时显示结果 2,结果以表格形式展现

  4. Assistant

    为实现这些功能,我们可以使用以下代码。将创建名为"phonebook.xlsx"的Excel文件,同时在文件中创建一个名为"Data"的工作表来添加数据。然后在Python文件中使用以下代码。确保安装了pandas & openpyxl模块。 pip install pandas openpyxl.

    from tkinter import *
    import pandas as pd
    from tkinter import ttk
    
    def on_key_release(event):
        search()
    
    
    def search():
        try:
            df = pd.read_excel('phonebook.xlsx', sheet_name='Data')
            phone = entry_phone.get()
    
            result = df.loc[df['phone'] == int(phone)] if phone else pd.DataFrame()  # Show data only when the phone number is entered
    
            resultsTable.delete(*resultsTable.get_children())
            for index, row in result.iterrows():
                resultsTable.insert("", "end", values=(row['name'], row['phone'], row['email']))
            if phone and not result.empty:
                resultsTable.grid(row=2, column=0, columnspan=2)
            else:
                resultsTable.grid_remove()
        except:
            resultsTable.grid_remove()
    
    def on_closing():
        root.destroy()
    
    root = Tk()
    root.title("Phonebook")
    
    frame = Frame(root)
    frame.pack()
    
    label = Label(frame, text="Enter Phone Number:")
    label.grid(row=0, column=0)
    
    entry_phone = Entry(frame)
    entry_phone.grid(row=0, column=1)
    entry_phone.bind('<KeyRelease>', on_key_release)
    
    resultsTable = ttk.Treeview(frame, columns=('Name', 'Phone', 'Email'), show='headings')
    resultsTable.heading('Name', text='Name')
    resultsTable.heading('Phone', text='Phone')
    resultsTable.heading('Email', text='Email')
    
    scrollbar = ttk.Scrollbar(frame, orient='vertical', command=resultsTable.yview)
    scrollbar.grid(row=2, column=2, sticky='ns')
    resultsTable.configure(yscrollcommand=scrollbar.set)
    
    root.protocol("WM_DELETE_WINDOW", on_closing)
    root.mainloop()
    

    此代码会直接在输入手机号时实时显示搜索结果,而不需要点击按钮。结果也会以表格形式显示在窗口中。