嘿,大家好,我想显示csv文件中选定的行,但我缺少了一些东西,它占了值的一半

  • 本文关键字:大家 一半 文件 csv 显示 python csv tkinter
  • 更新时间 :
  • 英文 :


下面是我的代码,csv文件看起来像

serail_number, Mac_Id
001, 19bc
002, 19bd
from tkinter import *
import tkinter.ttk as ttk
import csv
def OnDoubleClick(event):
item = tree.selection()
print('item:', item)
print('event:', event)
item = tree.selection()[0]
print("you clicked on", tree.item(item,"text"))
root = Tk()
root.title("Python - Import CSV File To Tkinter Table")
width = 500
height = 400
screen_width = root.winfo_screenwidth()
screen_height = root.winfo_screenheight()
x = (screen_width/2) - (width/2)
y = (screen_height/2) - (height/2)
root.geometry("%dx%d+%d+%d" % (width, height, x, y))
root.resizable(0, 0)
TableMargin = Frame(root, width=500)
TableMargin.pack(side=TOP)
scrollbarx = Scrollbar(TableMargin, orient=HORIZONTAL)
scrollbary = Scrollbar(TableMargin, orient=VERTICAL)
tree = ttk.Treeview(TableMargin, columns=("Serial number", "Mac Id"), height=400, selectmode="extended", yscrollcommand=scrollbary.set, xscrollcommand=scrollbarx.set)
scrollbary.config(command=tree.yview)
scrollbary.pack(side=RIGHT, fill=Y)
scrollbarx.config(command=tree.xview)
scrollbarx.pack(side=BOTTOM, fill=X)
tree.heading('Serial number', text="Serial number", anchor=W)
tree.heading('Mac Id', text="Mac Id", anchor=W)
tree.column('#0', stretch=NO, minwidth=0, width=0)
tree.column('#1', stretch=NO, minwidth=0, width=200)
tree.column('#2', stretch=NO, minwidth=0, width=200)
tree.bind("<<TreeviewSelect>>", OnDoubleClick)
tree.pack()
with open('data.csv') as f:
reader = csv.DictReader(f, delimiter=',')
for row in reader:
serial_number = row['serial_number']
Mac_Id = row['Mac_Id']
tree.insert("", 0, values=(serial_number, Mac_Id))
#Main
if __name__ == '__main__':
root.mainloop()**

因为当您选择时,它只打印第1行和第1列,但我想打印第1列、第1列和第2列,并将数据存储到变量中

更改此项:

print("you clicked on", tree.item(item,"text"))

到此:

values = tree.item(tree.selection())['values']
print("you clicked on", item, values)

或者对于一个列表中的所有内容,请使用:

values = [item] + tree.item(tree.selection())['values']
print("you clicked on", values)

最新更新