Das deutsche Python-Forum

Code: Alles auswählen

# globale Variable
tree = None

# import Pakete
from tkinter import PhotoImage
from tkinter import filedialog
from openpyxl import load_workbook
from datetime import datetime
import tkinter as tk
import tkinter.ttk as ttk
import pandas as pd

# importieren von Klassen

############## Hauptfenster erstellen ##############
root = tk.Tk()                                  # Hauptfenster aufrufen
root.title("BestMonkeyMoments")                 # Programmnamen definieren
root.geometry('1100x700')                        # größe des Hauptfensters definieren (breite x höhe)
icon = PhotoImage(file='images/monkey.png')     # der Pfad zum Icon/Bild
root.iconphoto(True, icon)                      # Set the icon for the window

Canvas = tk.Canvas
Button = tk.Button
LabelFrame = tk.LabelFrame

############## Button Größe ####################

ButW = 20
ButH = 1

############## Funktion erstellen ##############
################################################

# Funktion zum Öffnen des Excel-Files und Auslesen des Inhalts
def aktionSF1():
    # Öffne den Dateiauswahl-Dialog
    file_path = filedialog.askopenfilename(title= "Bitte Kammlinien-Datei wählen: ", initialdir="/Kammlinie", filetypes=[("Excel Files", "*.xlsx")])
    if not file_path:
        return
    Data = pd.read_excel(file_path)

    # Erstellen der Tabelle mit den gewünschten Abmessungen
    tree = ttk.Treeview(table_frame, height=50) # height = anzahl Zeilen die angezeigt werden
    tree["columns"] = list(Data.columns)
    tree["show"] = "headings"
    for column in tree["columns"]:
        tree.heading(column, text=column)
        tree.column(column, width=25)
    # Hinzufügen der Daten zur Tabelle
    for index, row in Data.iterrows():
        tree.insert("", "end", values=list(row))
    # Anzeigen der Tabelle im Frame
    tree.pack(side="top", fill="both", expand=True)

def aktionSF2():
    print(1)

def aktionSF3():
    print(2)

def aktionSF4():
    print(3)

def aktionSF5():
    print(4)

############## Frame generieren ##############

Frame1 = LabelFrame(root, text=" Input Programm ", font =('Arial', 14), width=290, height=200, padx=5, pady=5)
Frame1.place(x=10,y=10)

Frame2 = LabelFrame(root, text=" Stammdaten-Pflege ", font =('Arial', 14), width=290, height=200, padx=5, pady=5)
Frame2.place(x=10,y=210)

Frame3 = LabelFrame(root, text=" Simulation ", font =('Arial', 14), width=290, height=200, padx=5, pady=5)
Frame3.place(x=10,y=410)

Frame4 = LabelFrame(root, text=" Anzeige ", font =('Arial', 14), width=300, height=300, padx=5, pady=5)
Frame4.place(x=250,y=10)


############ Inhalt Frame 4 ####################
dataframe_widget = tk.Frame(Frame4, width=500, height=600)

############ Erstellen des Frames für die Tabelle mit den gewünschten Abmessungen
table_frame = ttk.Frame(Frame4, width=400, height=400)
table_frame.pack(side="top", fill="both", expand=True, padx=10, pady=10)



############## Buttons Frame 1 ##############

fr1But1 = Button(Frame1, text="Kammlinie", anchor="w", command=aktionSF1, width=ButW, height=ButH)
fr1But1.grid(row=0, column=0)

fr1But2 = Button(Frame1, text="Werkskalender", anchor="w", command=aktionSF2, width=ButW, height=ButH)
fr1But2.grid(row=1, column=0)

fr1But3 = Button(Frame1, text="Produktionsvorschau", anchor="w", command=aktionSF3, width=ButW, height=ButH)
fr1But3.grid(row=2, column=0)

############## Buttons Frame 2 ##############

fr2But1 = Button(Frame2, text="Derivate", anchor="w", command=aktionSF1, width=ButW, height=ButH)
fr2But1.grid(row=0, column=0)

fr2But2 = Button(Frame2, text="Zus. Prod. Sys", anchor="w", command=aktionSF2, width=ButW, height=ButH)
fr2But2.grid(row=1, column=0)

fr2But3 = Button(Frame2, text="Speicherverwaltung", anchor="w", command=aktionSF3, width=ButW, height=ButH)
fr2But3.grid(row=2, column=0)

fr2But4 = Button(Frame2, text="Restriktionen", command=aktionSF4, anchor="w",width=ButW, height=ButH)
fr2But4.grid(row=3, column=0)

############## Buttons Frame 3 ##############

fr3But1 = Button(Frame3, text="Play", anchor="w", command=aktionSF1, width=ButW, height=ButH)
fr3But1.grid(row=0, column=0)

fr3But2 = Button(Frame3, text="Typauswahl", anchor="w", command=aktionSF2, width=ButW, height=ButH)
fr3But2.grid(row=1, column=0)

fr3But3 = Button(Frame3, text="Zeitraum", anchor="w", command=aktionSF3, width=ButW, height=ButH)
fr3But3.grid(row=2, column=0)

fr3But4 = Button(Frame3, text="Restriktionen", command=aktionSF4, anchor="w",width=ButW, height=ButH)
fr3But4.grid(row=3, column=0)

fr3But5 = Button(Frame3, text="Historie", anchor="w", command=aktionSF5, width=ButW, height=ButH)
fr3But5.grid(row=4, column=0)

fr3But6 = Button(Frame3, text="Beenden", anchor="w", command=root.destroy, width=ButW, height=ButH)
fr3But6.grid(row=4, column=0)

############## Aktuelle Uhrzeit beim Programmstart ##############
now = datetime.now()
dt_string = now.strftime("%H:%M:%S")
print(dt_string)

############## Endlosschleife bis Quit ##############
root.mainloop()

Code: Alles auswählen

#!/usr/bin/env python3
import tkinter as tk
from datetime import datetime
from functools import partial
from tkinter import filedialog, ttk

import pandas as pd


def open_kammlinien_file(table_frame):
    file_path = filedialog.askopenfilename(
        title="Bitte Kammlinien-Datei wählen",
        initialdir="/Kammlinie",
        filetypes=[("Excel Files", "*.xlsx")],
    )
    if file_path:
        data = pd.read_excel(file_path)
        tree = ttk.Treeview(table_frame, height=50)
        tree["columns"] = list(data.columns)
        tree["show"] = "headings"
        for column in tree["columns"]:
            tree.heading(column, text=column)
            tree.column(column, width=25)

        for _, row in data.iterrows():
            tree.insert("", tk.END, values=list(row))

        tree.pack(side=tk.TOP, fill=tk.BOTH, expand=True)


def main():
    root = tk.Tk()
    root.title("BestMonkeyMoments")
    icon = PhotoImage(file="images/monkey.png")
    root.iconphoto(True, icon)

    button_frames_frame = tk.Frame(root)
    button_frames_frame.pack(side=tk.LEFT)

    frame = tk.LabelFrame(
        button_frames_frame, text="Input Programm", padx=5, pady=5
    )
    frame.pack(side=tk.TOP)
    open_kammlinie_button = tk.Button(frame, text="Kammlinie")
    open_kammlinie_button.grid(row=0, column=0)
    tk.Button(frame, text="Werkskalender", command=partial(print, 1)).grid(
        row=1, column=0
    )
    tk.Button(
        frame, text="Produktionsvorschau", command=partial(print, 2)
    ).grid(row=2, column=0)

    frame = tk.LabelFrame(
        button_frames_frame, text="Stammdaten-Pflege", padx=5, pady=5
    )
    frame.pack(side=tk.TOP)
    tk.Button(frame, text="Derivate", command=partial(print, 0)).grid(
        row=0, column=0
    )
    tk.Button(frame, text="Zus. Prod. Sys", command=partial(print, 1)).grid(
        row=1, column=0
    )
    tk.Button(
        frame, text="Speicherverwaltung", command=partial(print, 2)
    ).grid(row=2, column=0)
    tk.Button(frame, text="Restriktionen", command=partial(print, 3)).grid(
        row=3, column=0
    )

    frame = tk.LabelFrame(
        button_frames_frame, text="Simulation", padx=5, pady=5
    )
    frame.pack(side=tk.TOP)
    tk.Button(frame, text="Play", command=partial(print, 0)).grid(
        row=0, column=0
    )
    tk.Button(frame, text="Typauswahl", command=partial(print, 1)).grid(
        row=1, column=0
    )
    tk.Button(frame, text="Zeitraum", command=partial(print, 2)).grid(
        row=2, column=0
    )
    tk.Button(frame, text="Restriktionen", command=partial(print, 3)).grid(
        row=3, column=0
    )
    tk.Button(frame, text="Historie", command=partial(print, 4)).grid(
        row=4, column=0
    )
    tk.Button(frame, text="Beenden", command=root.destroy).grid(
        row=5, column=0
    )

    frame = tk.LabelFrame(root, text="Anzeige", padx=5, pady=5)
    frame.pack(side=tk.LEFT, fill=tk.BOTH, expand=True)
    table_frame = ttk.Frame(frame, width=400, height=400)
    table_frame.pack(side=tk.TOP, fill=tk.BOTH, expand=True, padx=10, pady=10)

    open_kammlinie_button["command"] = partial(
        open_kammlinien_file, table_frame
    )

    print(f"{datetime.now():%H:%M:%S}")
    root.mainloop()


if __name__ == "__main__":
    main()