我正在使用 Tkinter 撰寫一個簡單的計時器。我希望我的代碼保存在 Excel 檔案中激活停止按鈕時計時器顯示的時間。計時器作業正常，但資料僅存盤在 Excel 檔案的一行中。我希望它在例如一行中的 5 個單元格被填充時更改行。
我一直在嘗試使用條件for回圈。EG 我嘗試min_row每次單元格值增加 1not None但它不起作用。
有人可以告訴我我做錯了什么嗎？
# ***** IMPORTS *****
import tkinter as tk
from openpyxl import Workbook
from openpyxl import load_workbook
running = False
# time variables initially set to 0
hours, minutes, seconds, total_time = 0, 0, 0, 0
def start():
global running
if not running:
update()
running = True
# pause function
def pause():
global running
if running:
# cancel updating of time using after_cancel()
stopwatch_label.after_cancel(update_time)
running = False
# reset function
def reset():
global running
if running:
# cancel updating of time using after_cancel()
stopwatch_label.after_cancel(update_time)
running = False
# set variables back to zero
global hours, minutes, seconds
hours, minutes, seconds = 0, 0, 0
# set label back to zero
stopwatch_label.config(text='00:00:00')
# update stopwatch function
def update():
# update seconds with (addition) compound assignment operator
global hours, minutes, seconds, total_time
seconds = 1
total_time = 1
if seconds == 60:
minutes = 1
seconds = 0
if minutes == 60:
hours = 1
minutes = 0
# format time to include leading zeros
hours_string = f'{hours}' if hours > 9 else f'0{hours}'
minutes_string = f'{minutes}' if minutes > 9 else f'0{minutes}'
seconds_string = f'{seconds}' if seconds > 9 else f'0{seconds}'
# update timer label after 1000 ms (1 second)
stopwatch_label.config(text=hours_string ':' minutes_string ':' seconds_string)
global update_time
update_time = stopwatch_label.after(1000, update)
def excel_update():
dest_filename = r"C:\Users\abbas\OneDrive\Desktop\Prog\Flex\tider.xlsx"
#dest_filename = r"C:\Users\abbas\OneDrive\Desktop\Prog\Flex\test.xlsx"
wb = load_workbook(dest_filename)
ws = wb.active
next_row = 1
cell_range = ws.iter_rows(min_row=next_row, max_row=3, max_col=2)
#cell_range = ws["A1":"B3"]
for rows in cell_range:
for columns in rows:
if columns.value[columns] is None:
columns.value[columns] = total_time
break
wb.save(dest_filename)
# ***** WIDGETS *****
# create main window
root = tk.Tk()
#root.geometry('450x200')
root.resizable(width=False, height=False)
root.title('Stopwatch')
# label to display time
stopwatch_label = tk.Label(text='00:00:00', font=('Arial', 20))
stopwatch_label.pack()
# start, pause, reset, stop buttons
start_button = tk.Button(text='start', height=3, width=5, font=('Arial', 10), command=start)
start_button.pack(side=tk.LEFT)
stop_button = tk.Button(text='stop', height=3, width=5, font=('Arial', 10), command=lambda:[root.quit(), excel_update()])
stop_button.pack(side=tk.LEFT)
pause_button = tk.Button(text='pause', height=3, width=5, font=('Arial', 10), command=pause)
pause_button.pack(side=tk.LEFT)
reset_button = tk.Button(text='reset', height=3, width=5, font=('Arial', 10), command=reset)
reset_button.pack(side=tk.LEFT)
# ***** MAINLOOP *****
root.mainloop()
uj5u.com熱心網友回復：
根據您更新后的問題中的代碼，我認為更改excel_update()如下所示的功能將使其執行您想要的操作。
它從行的列中搜索到min_row空max_row的cell。如果找到它，它會為其分配時間值并引發StopIteration例外以跳出嵌套for回圈并終止搜索。然后簡單地忽略該例外，因為它是正常處理的一部分。
from tkinter.messagebox import showerror
def excel_update():
def excel_update():
dest_filename = r"C:\Users\abbas\OneDrive\Desktop\Prog\Flex\tider.xlsx"
wb = load_workbook(dest_filename)
ws = wb.active
# Put value in next empty cell in specified region (if one exists).
try:
for row in ws.iter_rows(min_row=1, max_row=3, max_col=3):
for cell in row:
if cell.value is None:
cell.value = total_time
raise StopIteration
else: # No exception raised.
showerror('Error!', 'No empty cells left for storing timer time!')
except StopIteration:
pass
wb.save(dest_filename) # Update file.
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/465737.html