Python 在不更改大小的情况下更新 Treeview 上的信息

问：

我有这段代码，我从 Excel 文件中读取并将其显示在 tkinter 应用程序的 Treeview 上。当程序启动时，Treeview 有一个大小，但是当我按下按钮再次打开文件时，它会改变大小并留下很多非覆盖部分。代码如下：

import pandas as pd
from tkinter import *
from tkinter import ttk, filedialog
import numpy as np
import datetime
import matplotlib.pyplot as plt
from matplotlib.backends.backend_tkagg import FigureCanvasTkAgg
import plotly.express as px


def opendir():
    filename = filedialog.askopenfilename(
        initialdir="C:/Inversiones/",
        title="Open a File", filetype=(("xlsx files", "*.xlsx"),
                                       ("All Files", "*.*"))
    )
    LoadDashboard(filename)


def buttonopendir():
    filename = path
    LoadDashboard(filename)


def loadTable(Filename, SheetName):
    if Filename:
        try:
            filename = r"{}".format(Filename)
            df = pd.read_excel(filename, sheet_name=SheetName)
        except ValueError:
            lblFileStatus.config(text="File Couldn't opened...try again")
        except FileNotFoundError:
            lblFileStatus.config(text="File Couldn't found...try again")
    return df


def ONPanel():
    filename = path
    df = loadTable(filename, 'InfoONs')
    clear_tree(treeDashboard)
    tickerlist['Tickers'] = list(df['Ticker ARS'])

    treeDashboard["columns"] = list(df.columns)
    treeDashboard["show"] = "headings"

    ColWidth = [70, 70, 230, 115, 40,
                50, 45, 70, 80, 80,
                120, 80, 80, 80, 30,
                40, 115, 100, 70, 60]

    i = 0
    for column in treeDashboard["column"]:
        treeDashboard.column(column, width=ColWidth[i], stretch=NO)
        treeDashboard.heading(column, text=column, anchor=W)
        i += 1

    df_rows = df.to_numpy().tolist()
    for row in df_rows:
        treeDashboard.insert("", "end", values=row)
    my_scroll1.config(command=treeDashboard.yview)

    for col in treeDashboard["columns"]:
        treeDashboard.heading(
            col, text=col, command=lambda c=col: sort_treeview(treeDashboard, c, False))
    treeDashboard.config(selectmode="extended")
    treeDashboard.pack()


def clear_tree(tree):
    tree.delete(*tree.get_children())


def sort_treeview(tree, col, descending):
    data = [(tree.set(item, col), item) for item in tree.get_children('')]
    data.sort(reverse=descending)
    for index, (val, item) in enumerate(data):
        tree.move(item, '', index)
    tree.heading(col, command=lambda: sort_treeview(tree, col, not descending))


WIDTH = 1800
HEIGHT = 1000
path = 'C:/Inversiones/ONs.xlsx'
tickerlist = {}

root = Tk()
root.title("Obligaciones Negociables")
root.geometry(str(WIDTH)+"x"+str(HEIGHT))


# Recuadro para la Pestaña Dashboard
my_frame1 = ttk.Frame(root, border=5)
my_frame1.pack()


# Recuadro para los Botones
my_subframe = ttk.Frame(my_frame1)
my_subframe.pack()

btnOpenExcel = Button(my_subframe, text="Abrir Excel", command=ONPanel)
btnOpenExcel.grid(row=0, column=0, padx=30)
lblFileStatus = Label(my_subframe, text='Archivo sin actualizar')
lblFileStatus.grid(row=0, column=1, padx=30)

# Recuadro para el Dashboard
my_subframe2 = ttk.Frame(my_frame1, height=500, width=1625)
my_subframe2.pack()


my_scroll1 = Scrollbar(my_subframe2)
my_scroll1.pack(side=RIGHT, fill=Y)
treeDashboard = ttk.Treeview(
    my_subframe2, yscrollcommand=my_scroll1.set, selectmode="extended", height=37)
ONPanel()

# Configuro el menu
my_menu = Menu(root)
root.config(menu=my_menu)
file_menu = Menu(my_menu, tearoff=False)
my_menu.add_cascade(label="File", menu=file_menu)
file_menu.add_command(label="Open", command=opendir)

root.mainloop()

这是表格 从我读到的数据：