2021 6 1 看不懂

Question

import tkinter as tk
import xlrd

root = tk.Tk()

workbook = xlrd.open_workbook('V:\\Operations & Technology\\Infra\\Customer on Boarding\\MPLS\\IE_SDP_IP_Allocation_MasterFile.xls')

sheet1_object = workbook.sheet_by_index(0)
sheet2_object = workbook.sheet_by_index(1)

button2 = tk.Button(root,text='获取信息',width=10,command=show)\
                            .grid(row=0,column=2)

tk.mainloop()

Answer 1

import tkinter as tk #导入模块
import xlrd

#创建tkinter窗体

root = tk.Tk()

#读取excel表格内容

workbook = xlrd.open_workbook('V:\\Operations & Technology\\Infra\\Customer on Boarding\\MPLS\\IE_SDP_IP_Allocation_MasterFile.xls')

#根据sheet索引或者名称获取sheet内容

sheet1_object = workbook.sheet_by_index(0)
sheet2_object = workbook.sheet_by_index(1)

#创建按钮
button2 = tk.Button(root,text='获取信息',width=10,command=show)\
                            .grid(row=0,column=2)

#显示
tk.mainloop()