我想獲取輸入'-Name-'的值并將其傳遞給openpyxl中的值
但問題是 (value = '-name-') openpyxl 不接受它。
test.cell(row=8,column=16).value='-Name-'
import PySimpleGUI as sg
from openpyxl import load_workbook, workbook
wb = load_workbook('test.xlsx')
test = wb.active
layout = [[sg.Text('name of employe')],
[sg.Text('Name', size=(15,1)), sg.InputText(key='-Name-')],
[sg.Button('OK'), sg.Button('Exit')]]
test.cell(row=8,column=16).value='-Name-'
window = sg.Window('title', layout)
while True:
event, values = window.read()
if event == sg.WIN_CLOSED or event == 'Exit':
break
elif event == 'OK':
wb.save('test.xlsx')
window.close()
uj5u.com熱心網友回復：
您要保存的不是字串'-Name-'，而是'OK'單擊此處的按鈕事件后 Input 元素的內容。
import PySimpleGUI as sg
from openpyxl import load_workbook, workbook
wb = load_workbook('test.xlsx')
test = wb.active
layout = [[sg.Text('name of employe')],
[sg.Text('Name', size=(15,1)), sg.InputText(key='-Name-')],
[sg.Button('OK'), sg.Button('Exit')]]
window = sg.Window('title', layout)
while True:
event, values = window.read()
if event == sg.WIN_CLOSED or event == 'Exit':
break
elif event == 'OK':
value = values['-Name-']
test.cell(row=8, column=16).value = value
wb.save('test.xlsx')
window.close()
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/450103.html
標籤：Python python-3.x 打开pyxl pysimplegui
下一篇：回傳游戲和結果的摘要