关于向exce表格中插入列表的问题

zhudaming120

1. import tkinter as tk
   
2. from tkinter import *
   
3. from openpyxl import load_workbook
   
4. import datetime as tm
   
5. import os
   
6. import xlrd
   
7. import xlwt
   
8. win = tk.Tk()
   
9. win.title("管理系统")
   
10. win.geometry("800x700")
    
11. var1 = tk.StringVar()
    
12. l = tk.Label(win,bg="yellow",width=4,textvariable=var1)
    
13. l.pack()
    
14. def pringt_selection():
    
15.     value1 = lb.get(lb.curselection())
    
16.     value = value1[:-5]
    
17. 
    
18. 
    
19.     var1.set(value)
    
20.     print(value)
    
21.     workbook = load_workbook("D:\\例子\\%s.xlsx" % (value))
    
22.     sheet = workbook.active
    
23.     cell = sheet["A1"]
    
24.     cell.value = "haha"
    
25.     workbook.save("D:\\例子\\%s.xlsx" % (value))
    
26. 
    
27. b1 = tk.Button(win,text="111",width=15,height=2,command=pringt_selection)
    
28. b1.pack()
    
29. 
    
30. var2=tk.StringVar()
    
31. #var2.set((11,22,33,44))
    
32. 
    
33. lb=tk.Listbox(win,listvariable=var2)
    
34. for i in os.listdir("D:\\例子\"):
    
35.     lb.insert("end",i)
    
36. lb.pack()
    
37. 
    
38. win.mainloop()

复制代码

按照这样的代码实现了向特定excell表格中插入内容

1. import tkinter as tk
   
2. from tkinter import *
   
3. from openpyxl import load_workbook
   
4. import datetime as tm
   
5. import os
   
6. import xlrd
   
7. import xlwt
   
8. win = tk.Tk()
   
9. win.title("管理系统")
   
10. win.geometry("800x700")
    
11. var1 = tk.StringVar()
    
12. l = tk.Label(win,bg="yellow",width=4,textvariable=var1)
    
13. l.pack()
    
14. def pringt_selection():
    
15.     value1 = lb.get(lb.curselection())
    
16.     value = value1[:-5]
    
17. 
    
18. 
    
19.     var1.set(value)
    
20.     print(value)
    
21.     workbook = load_workbook("D:\\例子\\%s.xlsx" % (value))
    
22.     sheet = workbook.active
    
23.     data =["时间","地点","人物"]
    
24.     for i in data:
    
25.         sheet.append(i)
    
26.     workbook.save("D:\\例子\\%s.xlsx" % (value))
    
27. 
    
28. b1 = tk.Button(win,text="111",width=15,height=2,command=pringt_selection)
    
29. b1.pack()
    
30. 
    
31. var2=tk.StringVar()
    
32. #var2.set((11,22,33,44))
    
33. 
    
34. lb=tk.Listbox(win,listvariable=var2)
    
35. for i in os.listdir("D:\\例子\"):
    
36.     lb.insert("end",i)
    
37. lb.pack()
    
38. 
    
39. win.mainloop()

复制代码

但是将写入的内容换成列表后就会报错，
workbook = load_workbook("D:\\例子\\%s.xlsx" % (value))
    sheet = workbook.active
    data =["时间","地点","人物"]
    for i in data:
        sheet.append(i)
    workbook.save("D:\\例子\\%s.xlsx" % (value))
插入列表的错误在哪里，求正确的写法

rsj0315

不需要用for循环来添加列表的每一项。
直接sheet.append(data)
就可以了

zhudaming120

谢了 ，原来画蛇添足了

zhudaming120

rsj0315 发表于 2020-5-8 23:29
不需要用for循环来添加列表的每一项。
直接sheet.append(data)
就可以了

怎么不能给你最佳答案啊？

rsj0315

zhudaming120 发表于 2020-5-9 12:41
怎么不能给你最佳答案啊？

不清楚