|
|

楼主 |
发表于 2024-4-2 00:25:10
|
显示全部楼层
class ChangeFrame(tk.Frame):
def __init__(self, root):
super().__init__(root)
self.car_data = pd.read_excel(path_all.car_total_path)
self.box_data = pd.read_excel(path_all.box_total_path)
self.up_l_frame = tk.Frame(self)
self.up_l_frame.grid(row=0, column=0)
self.up_r_frame = tk.Frame(self)
self.up_r_frame.grid(row=0, column=1)
self.l_frame = tk.Frame(self)
self.l_frame.grid(row=1,column=0)
self.r_frame = tk.Frame(self)
self.r_frame.grid(row=1,column=1)
self.create_page()
def display_dataframe(self,df):
self.car_treeview.delete(*self.car_treeview.get_children())
for index, row in df.iterrows():
self.car_treeview.insert("", 'end', values=row.tolist())
def get_car_sheet(self):
# 从Excel读取数据到DataFrame
self.df1 = pd.read_excel(path_all.car_total_path, index_col=None)
self.df = self.df1[['车号','现金']].fillna(method='ffill')
self.df["现金"] = self.df["现金"].astype(float)
self.df['车号'] = self.df['车号'].str.upper()
self.df = self.df.dropna(axis=1, how='all')
# 在Treeview中显示DataFrame的所有数据
self.display_dataframe(self.df)
def car_treeview_laber(self):
self.car_yscroll = tk.Scrollbar(orient=tk.VERTICAL)
self.car_treeview = ttk.Treeview(self.l_frame,height=37, yscrollcommand=self.car_yscroll.set)# 创建一个Treeview控件
self.car_columns = ['车号', '现金']# 添加表头
self.car_treeview['columns'] = self.car_columns
for column in self.car_columns:
self.car_treeview.heading(column, text=column)
# 显示TreeView
self.get_car_sheet()
self.car_vsb = ttk.Scrollbar(orient='vertical', command=self.car_treeview.yview)
self.car_vsb.pack(side='right', fill='y')
self.car_treeview.column(column='#0', width=1)
self.car_treeview.column(column='车号', width=10, anchor='w')
self.car_treeview.column(column='现金', width=8, anchor='e')
# 设置TreeView的垂直滚动条
self.car_treeview.configure(yscrollcommand=self.car_vsb.set)
def create_page(self):
self.check_car_laber()
self.check_box_laber()
为什么会显示不出来
|
|