跳至主要内容

tkinter 练习之信息录入并保存进excel



Python提供了Tkinter工具包来开发GUI应用程序。现在，它取决于开发人员的想象力或必要性，他/她想要使用此工具包开发什么。让我们使用Tkinter制作一个简单的信息表格GUI应用程序。在此应用程序中，用户必须填写所需信息，并将该信息自动写入excel文件。

首先，创建一个空的excel文件，然后在程序中传递excel文件的绝对路径，以便程序能够访问该excel文件。

参考资料

https://www.geeksforgeeks.org/python-simple-registration-form-using-tkinter/


源码

# import openpyxl and tkinter modules
from openpyxl import *
from tkinter import *

# globally declare wb and sheet variable

# opening the existing excel file
wb = load_workbook('C:\\Users\\Admin\\Desktop\\excel.xlsx')

# create the sheet object
sheet = wb.active


def excel():

# resize the width of columns in
# excel spreadsheet
sheet.column_dimensions['A'].width = 30
sheet.column_dimensions['B'].width = 10
sheet.column_dimensions['C'].width = 10
sheet.column_dimensions['D'].width = 20
sheet.column_dimensions['E'].width = 20
sheet.column_dimensions['F'].width = 40
sheet.column_dimensions['G'].width = 50

# write given data to an excel spreadsheet
# at particular location
sheet.cell(row=1, column=1).value = "Name"
sheet.cell(row=1, column=2).value = "Course"
sheet.cell(row=1, column=3).value = "Semester"
sheet.cell(row=1, column=4).value = "Form Number"
sheet.cell(row=1, column=5).value = "Contact Nmber"
sheet.cell(row=1, column=6).value = "Email id"
sheet.cell(row=1, column=7).value = "Address"


# Function to set focus (cursor)
def focus1(event):
# set focus on the course_field box
course_field.focus_set()


# Function to set focus
def focus2(event):
# set focus on the sem_field box
sem_field.focus_set()


# Function to set focus
def focus3(event):
# set focus on the form_no_field box
form_no_field.focus_set()


# Function to set focus
def focus4(event):
# set focus on the contact_no_field box
contact_no_field.focus_set()


# Function to set focus
def focus5(event):
# set focus on the email_id_field box
email_id_field.focus_set()


# Function to set focus
def focus6(event):
# set focus on the address_field box
address_field.focus_set()


# Function for clearing the
# contents of text entry boxes
def clear():

# clear the content of text entry box
name_field.delete(0, END)
course_field.delete(0, END)
sem_field.delete(0, END)
form_no_field.delete(0, END)
contact_no_field.delete(0, END)
email_id_field.delete(0, END)
address_field.delete(0, END)


# Function to take data from GUI
# window and write to an excel file
def insert():

# if user not fill any entry
# then print "empty input"
if (name_field.get() == "" and
course_field.get() == "" and
sem_field.get() == "" and
form_no_field.get() == "" and
contact_no_field.get() == "" and
email_id_field.get() == "" and
address_field.get() == ""):

print("empty input")

else:

# assigning the max row and max column
# value upto which data is written
# in an excel sheet to the variable
current_row = sheet.max_row
current_column = sheet.max_column

# get method returns current text
# as string which we write into
# excel spreadsheet at particular location
sheet.cell(row=current_row + 1, column=1).value = name_field.get()
sheet.cell(row=current_row + 1, column=2).value = course_field.get()
sheet.cell(row=current_row + 1, column=3).value = sem_field.get()
sheet.cell(row=current_row + 1, column=4).value = form_no_field.get()
sheet.cell(row=current_row + 1, column=5).value = contact_no_field.get()
sheet.cell(row=current_row + 1, column=6).value = email_id_field.get()
sheet.cell(row=current_row + 1, column=7).value = address_field.get()

# save the file
wb.save('C:\\Users\\Admin\\Desktop\\excel.xlsx')

# set focus on the name_field box
name_field.focus_set()

# call the clear() function
clear()


# Driver code
if __name__ == "__main__":

# create a GUI window
root = Tk()

# set the background colour of GUI window
root.configure(background='light green')

# set the title of GUI window
root.title("registration form")

# set the configuration of GUI window
root.geometry("500x300")

excel()

# create a Form label
heading = Label(root, text="Form", bg="light green")

# create a Name label
name = Label(root, text="Name", bg="light green")

# create a Course label
course = Label(root, text="Course", bg="light green")

# create a Semester label
sem = Label(root, text="Semester", bg="light green")

# create a Form No. lable
form_no = Label(root, text="Form No.", bg="light green")

# create a Contact No. label
contact_no = Label(root, text="Contact No.", bg="light green")

# create a Email id label
email_id = Label(root, text="Email id", bg="light green")

# create a address label
address = Label(root, text="Address", bg="light green")

# grid method is used for placing
# the widgets at respective positions
# in table like structure .
heading.grid(row=0, column=1)
name.grid(row=1, column=0)
course.grid(row=2, column=0)
sem.grid(row=3, column=0)
form_no.grid(row=4, column=0)
contact_no.grid(row=5, column=0)
email_id.grid(row=6, column=0)
address.grid(row=7, column=0)

# create a text entry box
# for typing the information
name_field = Entry(root)
course_field = Entry(root)
sem_field = Entry(root)
form_no_field = Entry(root)
contact_no_field = Entry(root)
email_id_field = Entry(root)
address_field = Entry(root)

# bind method of widget is used for
# the binding the function with the events

# whenever the enter key is pressed
# then call the focus1 function
name_field.bind("<Return>", focus1)

# whenever the enter key is pressed
# then call the focus2 function
course_field.bind("<Return>", focus2)

# whenever the enter key is pressed
# then call the focus3 function
sem_field.bind("<Return>", focus3)

# whenever the enter key is pressed
# then call the focus4 function
form_no_field.bind("<Return>", focus4)

# whenever the enter key is pressed
# then call the focus5 function
contact_no_field.bind("<Return>", focus5)

# whenever the enter key is pressed
# then call the focus6 function
email_id_field.bind("<Return>", focus6)

# grid method is used for placing
# the widgets at respective positions
# in table like structure .
name_field.grid(row=1, column=1, ipadx="100")
course_field.grid(row=2, column=1, ipadx="100")
sem_field.grid(row=3, column=1, ipadx="100")
form_no_field.grid(row=4, column=1, ipadx="100")
contact_no_field.grid(row=5, column=1, ipadx="100")
email_id_field.grid(row=6, column=1, ipadx="100")
address_field.grid(row=7, column=1, ipadx="100")

# call excel function
excel()

# create a Submit Button and place into the root window
submit = Button(root, text="Submit", fg="Black",
bg="Red", command=insert)
submit.grid(row=8, column=1)

# start the GUI
root.mainloop()

标签：

评论

发表评论

此博客中的热门博文

Mongo 入门

https://pymongo.readthedocs.io/en/stable/tutorial.html https://www.mongodb.com/languages/python https://zhuanlan.zhihu.com/p/51171906 https://www.runoob.com/python3/python-mongodb.html https://blog.baoshuo.ren/post/luogu-spider/ https://hub.docker.com/_/mongo 安装 MongoDB $ docker search mongo 启动一个mongo服务器实例 $ docker run --name some-mongo -d mongo:tag some-mongo是您要分配给容器的名称，tag是指定您想要的 MongoDB 版本的标签 MongoDB 的默认数据目录路径是/data/db 如下： $ docker run -it -v mongodata:/data/db -p 27017:27017 --name mongodb --restart unless-stopped -d mongo 你应该让 MongoDB 在端口 27017 上运行，并且可以通过localhostWindows 和 Ubuntu 20.04 上的URL访问 http://localhost:27017/ -p 是 HOST_PORT:CLIENT_PORT  -P 随机端口 -p 27017:27017 :将容器的27017 端口映射到主机的27017 端口 -v mongodata:/data/db :将主机中当前目录下的db挂载到容器的/data/db，作为mongo数据存储目录 从另一个 Docker 容器连接到 MongoDB 镜像中的 MongoDB 服务器侦听标准 MongoDB 端口27017，因此通过 Docker 网络连接将与连接到远程mongod. 以下示例启动另一个 MongoDB 容器实例，并mongo针对上述示例中的原始 MongoDB 容器运行命令行客户端，从而允许您针对数据库实例执行 MongoDB 语句： $ docker run -it --network some-network --...
发表评论
阅读全文

端口映射 公网访问内网

https://portforward.com/ Holer 通过安全隧道将位于NAT和防火墙之后的本地服务器暴露给公共Internet。 Holer是一个将原型中的应用映射到公网访问的端口映射软件，支持转发基于TCP协议的报文 https://github.com/wisdom-projects/holer 方式一：使用（公告）的holer映射或者开通holer服务，通过holer客户端软件经 holer服务器实现公网访问。 公开的holer映射详情如下： 访问密钥 访问域名 公网地址 本地地址 使用场景 HOLER_CLIENT-2F8D8B78B3C2A0AE holer65530.wdom.net holer.org:65530 127.0.0.1:8080 网页 HOLER_CLIENT-3C07CDFD1BF99BF2 holer65531.wdom.net holer.org:65531 127.0.0.1:8088 网页 HOLER_CLIENT-2A623FCB6E2A7D1D holer65532.wdom.net holer.org:65532 127.0.0.1:80 网页 HOLER_CLIENT-AF3E6391525F70E4 不适用 holer.org:65533 127.0.0.1:3389 远程桌面 HOLER_CLIENT-822404317F9D8ADD 不适用 holer.org:65534 127.0.0.1:22 SSH协议 HOLER_CLIENT-27DD1389DF1D4DBC 不适用 holer.org:65535 127.0.0.1:3306 数据库 使用Java版本的holer客户端 ①java 1.7或者更高版本 ②下载holer-client.zip 修改配置文件C:\holer-client\conf\holer.conf HOLER_ACCESS_KEY=HOLER_CLIENT-2A623FCB6E2A7D1D HOLER_SERVER_HOST=holer65532.wdom.net ③建议先双击运行C:\holer-client\bin\shutdown.bat，再双击运行C:\holer-client\bin\startup.bat...
发表评论
阅读全文

安装和卸载软件（msi\exe）

如何判断一个软件是64位的还是32位的？ 情况1、 未安装--右键安装程序查看属性，兼容性，勾选兼容模式查看最低适配是vista的是64位，反之32位， 不太准确 情况2、 已安装--运行软件，64位操作系统打开任务管理器看进程后缀名，带*32就是32位，反之64位 https://www.joci.net/xxbk/126251/ FileMon 和 Regmon 不再可供下载。从Windows 2000 SP4，Windows XP SP2，Windows Server 2003 SP1和Windows Vista开始的Windows版本上，它们已被 Process Monitor 取代 https://adamtheautomator.com/procmon/ Process Monitor 是Windows的高级监视工具，它显示实时文件系统，注册表和进程/线程活动。 它结合了两个旧的Sysinternals实用程序 Filemon 和  Regmon的功能 ，并添加了广泛的增强功能列表，包括丰富的和非破坏性的过滤，全面的事件属性（例如会话ID和用户名），可靠的过程信息，带有集成符号的完整线程堆栈支持每个操作，同时记录到文件等。 它独特的强大功能将使Process Monitor成为您的系统故障排除和恶意软件搜索工具包中的核心实用程序。 https://wikileaks.org/ciav7p1/cms/page_42991626.html HKLM\Software\Microsoft\Cryptography\MachineGuid Machine GUID/Cryptography GUID---该密钥通常用作机器的唯一标识符。它也已用于将两台计算机链接在一起-在某些情况下，计算机GUID是与设备（MP3播放器等）一起传递的。 Machine GUID不是唯一 https://docs.microsoft.com/zh-cn/windows/win32/properties/props-system-identity-uniqueid?redirectedfrom=MSDN UniqueID才是唯一 注册表 是存储系统和应用程序的设置信息 打开注册表的方式很简单：cmd中输入regedit 卸载路径只有一个 已安装32位的程序，如果是系统是32位...
发表评论
阅读全文