[Python] 纯文本查看 复制代码import pandas as pd import tkinter as tk from tkinter import messagebox from datetime import datetime, timedelta import threading import time # 读取Excel文件 def read_excel(file_path): df = pd.read_excel(file_path) return df # 检查证件是否即将到期 def check_expiration(df): today = datetime.now() for index, row in df.iterrows(): expiration_date = datetime.strptime(row['有效日期'], '%Y-%m-%d') # 假设日期格式为'YYYY-MM-DD' if expiration_date - today
KeKeBB0609 发表于 2024-4-17 16:34 [mw_shl_code=python,true]import pandas as pd import tkinter as tk from tkinter import messageb ... 需要用到openpyxl和pandas库，main方法里的file_path = 'your_excel_file.xlsx'需要改成你的excel文件路径（如果在同一目录下可直接填写文件名，如果不在请填写绝对路径）。如果想要GUI界面可回复
KeKeBB0609 发表于 2024-4-17 16:34 [mw_shl_code=python,true]import pandas as pd import tkinter as tk from tkinter import messageb ... 你还是给他打包个EXE，他估计不知道这代码怎么用
