Danke, habe ich geändert und übergebe jetzt eine Liste mit den Wörter.
Code: Alles auswählen
#!/usr/bin/env python3
import re
import tkinter as tk
from datetime import datetime
from pathlib import Path
from tkinter import messagebox, ttk
from tkinter.filedialog import askdirectory
from collections import deque
from openpyxl import Workbook, load_workbook
WORKBOOK_WITH_READ_DATA = "Ausgelesene Werte.xlsx"
INFO_FILE = "Nicht gelesene Dateien.txt"
DEFAULT_CELL_NAMES = "Volumen, Drehzahl, Gas"
class App(tk.Frame):
def __init__(self, master):
tk.Frame.__init__(self, master)
master.columnconfigure(0, weight=100)
self.user_select = tk.StringVar()
self.user_select.set("<Kein Oderne ausgewählt>")
ttk.Label(self, text="Ausgewählter Ordner:").grid(row=0, column=0, sticky=tk.W)
self.selected_folder = tk.Label(self, textvariable=self.user_select)
self.selected_folder.grid(row=1, column=0, sticky=tk.W)
ttk.Button(self, text="Ordner auswählen", command=self.open_dialog).grid(
row=2, column=0, sticky=tk.W
)
ttk.Label(self, text="Zellennamen die ausgelesen werden sollen").grid(
row=0, column=4, sticky=tk.W
)
ttk.Label(self, text="getrennt mit Komma eingeben:").grid(
row=1, column=4, sticky=tk.W
)
self.cells_to_read = tk.StringVar()
self.cells_to_read.set(DEFAULT_CELL_NAMES)
ttk.Entry(self, textvariable=self.cells_to_read).grid(
row=2, column=4, sticky=tk.W
)
ttk.Button(self, text="Auslesen", command=self.transfer_gui_data).grid(
row=5, column=5
)
ttk.Button(self, text="Beenden", command=self.quit).grid(
row=5, column=4, sticky=tk.E
)
self.coffee = ttk.Label(self, text="Zeit für Kaffee...")
self.process_bar = ttk.Progressbar(self)
self.files_to_be_processed = deque()
self.folder_path = None
def open_dialog(self):
self.folder_path = Path(askdirectory(mustexist=True))
self.user_select.set(self.folder_path.name)
def add_files(self, file):
self.files_to_be_processed.append(file)
def remove_file(self):
self.files_to_be_processed.popleft()
def transfer_gui_data(self):
control_program_sequence(
self.cells_to_read, self.folder_path, self.add_files, self.remove_file
)
def control_program_sequence(cells_to_read, folder_path, add_files, remove_file):
info_file = False
timestamp = datetime.now().strftime("%Y%m%d_%H%M")
collect_xls_files(folder_path, add_files)
keywords = keywords_to_list(cells_to_read.get().split(","))
workbook, output_file = open_output_file(timestamp, folder_path)
worksheet = workbook.active
for filename in folder_path.glob("**/*.xlsx"):
if filename.name.split("_")[-1] != WORKBOOK_WITH_READ_DATA:
keyword_to_row_content = read_excel_file(filename, keywords)
not_found_keywords = set(name.lower() for name in keywords) - set(
name.lower() for name in keyword_to_row_content
)
if not not_found_keywords:
write_into_output_file(worksheet, keyword_to_row_content)
else:
write_info_file(timestamp, folder_path, filename, not_found_keywords)
info_file = True
remove_file()
workbook.save(output_file)
if info_file:
messagebox.showinfo(
"Info Datei",
"Nicht alle gefundenen Dateien konnten gelesen werden, bitte Info-Datei beachten.",
)
def collect_xls_files(folder_path, add_files):
for file in folder_path.glob("**/*.xlsx"):
if file.name.split("_")[-1] != WORKBOOK_WITH_READ_DATA:
add_files(file)
def find_keyword(description, keywords):
match = re.search(rf"\b({'|'.join(keywords)})\b", description, re.IGNORECASE)
if match:
return match.group(1)
return None
def keywords_to_list(cells_to_read):
return [keyword.strip() for keyword in cells_to_read]
def open_output_file(timestamp, folder_path):
output_file = folder_path / f"{timestamp}_{WORKBOOK_WITH_READ_DATA}"
if output_file.exists():
workbook = load_workbook(output_file)
else:
workbook = Workbook()
return workbook, output_file
def read_excel_file(filename, keywords):
keyword_to_row_content = {}
worksheet = load_workbook(filename)["Tabelle1"]
for description, content in worksheet.iter_rows(min_col=1, max_col=2):
keyword = find_keyword(description.value, keywords)
if keyword is not None:
keyword_to_row_content[keyword] = content.value
return keyword_to_row_content
def write_info_file(timestamp, folder_path, file, not_found_keywords):
with (folder_path / f"{timestamp}_{INFO_FILE}").open(
"a", encoding="UTF-8"
) as info_file:
info_file.write(
f'-> In der Datei "{file}" wurden folgende Suchwörter nicht gefunden: {not_found_keywords}'
)
def write_into_output_file(worksheet, keyword_to_row_content):
for row in keyword_to_row_content.items():
worksheet.append(row)
def main():
root = tk.Tk()
root.title("Auswertung")
app = App(root)
app.pack()
app.mainloop()
if __name__ == "__main__":
main()
Code: Alles auswählen
@property
def progress(self):
return 100 - (100 * len(self.files_to_be_processed) / self.number_of_all_files)Wie ich das umsetzen soll verstehe ich noch nicht ganz. Bis jetzt gehe ich davon aus, dass das Programm sich die Anzahl aller Dateien merken muss und wenn ich die Logik nicht in eine extra Klasse packe, dann stehe ich hier gerade etwas auf dem Schlauch.Im einfachsten Fall gibt heißt der Callback ja einfach progress und bekommt eine Prozentzahl.
Code: Alles auswählen
def do_something(..., on_progress=lambda percentage: None):
items = get_items()
for number, item in enumerate(items, 1):
on_progress(number / len(items) * 100)
...
...Code: Alles auswählen
#!/usr/bin/env python3
import re
import tkinter as tk
from datetime import datetime
from pathlib import Path
from tkinter import messagebox, ttk
from tkinter.filedialog import askdirectory
from collections import deque
from openpyxl import Workbook, load_workbook
from time import sleep
WORKBOOK_WITH_READ_DATA = "Ausgelesene Werte.xlsx"
INFO_FILE = "Nicht gelesene Dateien.txt"
DEFAULT_CELL_NAMES = "Volumen, Drehzahl, Gas"
class App(tk.Frame):
def __init__(self, master):
tk.Frame.__init__(self, master)
master.columnconfigure(0, weight=100)
self.user_select = tk.StringVar()
self.user_select.set("<Kein Oderne ausgewählt>")
ttk.Label(self, text="Ausgewählter Ordner:").grid(row=0, column=0, sticky=tk.W)
self.selected_folder = tk.Label(self, textvariable=self.user_select)
self.selected_folder.grid(row=1, column=0, sticky=tk.W)
ttk.Button(self, text="Ordner auswählen", command=self.open_dialog).grid(
row=2, column=0, sticky=tk.W
)
ttk.Label(self, text="Zellennamen die ausgelesen werden sollen").grid(
row=0, column=4, sticky=tk.W
)
ttk.Label(self, text="getrennt mit Komma eingeben:").grid(
row=1, column=4, sticky=tk.W
)
self.cells_to_read = tk.StringVar()
self.cells_to_read.set(DEFAULT_CELL_NAMES)
ttk.Entry(self, textvariable=self.cells_to_read).grid(
row=2, column=4, sticky=tk.W
)
ttk.Button(self, text="Auslesen", command=self.transfer_gui_data).grid(
row=5, column=5
)
ttk.Button(self, text="Beenden", command=self.quit).grid(
row=5, column=4, sticky=tk.E
)
self.coffee = ttk.Label(self, text="Zeit für Kaffee...")
self.process_bar = ttk.Progressbar(self)
self.process = deque()
self.folder_path = None
self.process_status = False
def open_dialog(self):
self.folder_path = Path(askdirectory(mustexist=True))
self.user_select.set(self.folder_path.name)
def on_progress(self, percentage):
try:
self.process.popleft()
except IndexError:
pass
self.process.append(percentage)
if percentage == 100:
self.process_status = True
def update_process(self):
# Instead of print -> progressbar or label with percent
print(self.process)
if not self.process_status:
self.after(10, self.update_process)
else:
self.process_status = False
def transfer_gui_data(self):
self.update_process()
control_program_sequence(
self.cells_to_read.get(), self.folder_path, self.on_progress
)
def control_program_sequence(cells_to_read, folder_path, on_progress=lambda percentage: None):
info_file = False
timestamp = datetime.now().strftime("%Y%m%d_%H%M")
keywords = keywords_to_list(cells_to_read)
workbook, output_file = open_output_file(timestamp, folder_path)
worksheet = workbook.active
files = collect_files(folder_path)
for number, filename in enumerate(files, 1):
on_progress(number / len(files) * 100)
keyword_to_row_content = read_excel_file(filename, keywords)
not_found_keywords = set(name.lower() for name in keywords) - set(
name.lower() for name in keyword_to_row_content
)
if not not_found_keywords:
write_into_output_file(worksheet, keyword_to_row_content)
else:
write_info_file(timestamp, folder_path, filename, not_found_keywords)
info_file = True
sleep(0.5)
workbook.save(output_file)
if info_file:
messagebox.showinfo(
"Info Datei",
"Nicht alle gefundenen Dateien konnten gelesen werden, bitte Info-Datei beachten.",
)
def collect_files(folder_path):
files = []
for file in folder_path.glob("**/*.xlsx"):
if file.name.split("_")[-1] != WORKBOOK_WITH_READ_DATA:
files.append(file)
return files
def find_keyword(description, keywords):
match = re.search(rf"\b({'|'.join(keywords)})\b", description, re.IGNORECASE)
if match:
return match.group(1)
return None
def keywords_to_list(cells_to_read):
return [keyword.strip() for keyword in cells_to_read.split(",")]
def open_output_file(timestamp, folder_path):
output_file = folder_path / f"{timestamp}_{WORKBOOK_WITH_READ_DATA}"
if output_file.exists():
workbook = load_workbook(output_file)
else:
workbook = Workbook()
return workbook, output_file
def read_excel_file(filename, keywords):
keyword_to_row_content = {}
worksheet = load_workbook(filename)["Tabelle1"]
for description, content in worksheet.iter_rows(min_col=1, max_col=2):
keyword = find_keyword(description.value, keywords)
if keyword is not None:
keyword_to_row_content[keyword] = content.value
return keyword_to_row_content
def write_info_file(timestamp, folder_path, file, not_found_keywords):
with (folder_path / f"{timestamp}_{INFO_FILE}").open(
"a", encoding="UTF-8"
) as info_file:
info_file.write(
f'-> In der Datei "{file}" wurden folgende Suchwörter nicht gefunden: {not_found_keywords}'
)
def write_into_output_file(worksheet, keyword_to_row_content):
for row in keyword_to_row_content.items():
worksheet.append(row)
def main():
root = tk.Tk()
root.title("Auswertung")
app = App(root)
app.pack()
app.mainloop()
if __name__ == "__main__":
main()
Code: Alles auswählen
#!/usr/bin/env python3
import re
import tkinter as tk
from datetime import datetime
from pathlib import Path
from queue import Queue
from threading import Thread
from tkinter import messagebox, ttk
from tkinter.filedialog import askdirectory
from openpyxl import Workbook, load_workbook
WORKBOOK_WITH_READ_DATA = "Ausgelesene Werte.xlsx"
INFO_FILE = "Nicht gelesene Dateien.txt"
DEFAULT_CELL_NAMES = "Volumen, Drehzahl, Gas"
class App(tk.Frame):
def __init__(self, master):
tk.Frame.__init__(self, master)
master.columnconfigure(0, weight=100)
self.user_select = tk.StringVar()
self.user_select.set("<Kein Oderne ausgewählt>")
ttk.Label(self, text="Ausgewählter Ordner:").grid(row=0, column=0, sticky=tk.W)
self.selected_folder = tk.Label(self, textvariable=self.user_select)
self.selected_folder.grid(row=1, column=0, sticky=tk.W)
ttk.Button(self, text="Ordner auswählen", command=self.open_dialog).grid(
row=2, column=0, sticky=tk.W
)
ttk.Label(self, text="Zellennamen die ausgelesen werden sollen").grid(
row=0, column=4, sticky=tk.W
)
ttk.Label(self, text="getrennt mit Komma eingeben:").grid(
row=1, column=4, sticky=tk.W
)
self.cells_to_read = tk.StringVar()
self.cells_to_read.set(DEFAULT_CELL_NAMES)
ttk.Entry(self, textvariable=self.cells_to_read).grid(
row=2, column=4, sticky=tk.W
)
ttk.Button(self, text="Auslesen", command=self.transfer_gui_data).grid(
row=5, column=5
)
ttk.Button(self, text="Beenden", command=self.quit).grid(
row=5, column=4, sticky=tk.E
)
self.process_in_percent = tk.StringVar()
ttk.Label(self, textvariable=self.process_in_percent).grid(row=4, column=4)
self.process = Queue()
self.folder_path = None
def open_dialog(self):
self.folder_path = Path(askdirectory(mustexist=True))
self.user_select.set(self.folder_path.name)
def on_progress(self, percentage):
self.process.put(percentage)
@staticmethod
def show_info_file_message(status):
if status:
messagebox.showinfo(
"Info Datei",
"Nicht alle gefundenen Dateien konnten gelesen werden, bitte Info-Datei beachten.",
)
def update_process(self):
percent = self.process.get(block=True)
self.process_in_percent.set(f"{percent} %")
if percent != 100:
self.after(10, self.update_process)
else:
self.process_in_percent.set("Fertig!")
def transfer_gui_data(self):
Thread(
target=control_program_sequence,
args=[
self.cells_to_read.get(),
self.folder_path,
self.on_progress,
self.show_info_file_message,
],
).start()
self.update_process()
def control_program_sequence(
cells_to_read,
folder_path,
on_progress=lambda percentage: None,
show_info_file_message=lambda status: False,
):
info_file = False
timestamp = datetime.now().strftime("%Y%m%d_%H%M")
keywords = keywords_to_list(cells_to_read)
workbook, output_file = open_output_file(timestamp, folder_path)
worksheet = workbook.active
files = collect_files(folder_path)
for number, filename in enumerate(files, 1):
on_progress(number / len(files) * 100)
keyword_to_row_content = read_excel_file(filename, keywords)
not_found_keywords = set(name.lower() for name in keywords) - set(
name.lower() for name in keyword_to_row_content
)
if not not_found_keywords:
write_into_output_file(worksheet, keyword_to_row_content)
else:
write_info_file(timestamp, folder_path, filename, not_found_keywords)
info_file = True
workbook.save(output_file)
if info_file:
show_info_file_message(True)
else:
show_info_file_message(False)
def collect_files(folder_path):
files = []
for file in folder_path.glob("**/*.xlsx"):
if file.name.split("_")[-1] != WORKBOOK_WITH_READ_DATA:
files.append(file)
return files
def find_keyword(description, keywords):
match = re.search(rf"\b({'|'.join(keywords)})\b", description, re.IGNORECASE)
if match:
return match.group(1)
return None
def keywords_to_list(cells_to_read):
return [keyword.strip() for keyword in cells_to_read.split(",")]
def open_output_file(timestamp, folder_path):
output_file = folder_path / f"{timestamp}_{WORKBOOK_WITH_READ_DATA}"
if output_file.exists():
workbook = load_workbook(output_file)
else:
workbook = Workbook()
return workbook, output_file
def read_excel_file(filename, keywords):
keyword_to_row_content = {}
worksheet = load_workbook(filename)["Tabelle1"]
for description, content in worksheet.iter_rows(min_col=1, max_col=2):
keyword = find_keyword(description.value, keywords)
if keyword is not None:
keyword_to_row_content[keyword] = content.value
return keyword_to_row_content
def write_info_file(timestamp, folder_path, file, not_found_keywords):
with (folder_path / f"{timestamp}_{INFO_FILE}").open(
"a", encoding="UTF-8"
) as info_file:
info_file.write(
f'-> In der Datei "{file}" wurden folgende Suchwörter nicht gefunden: {not_found_keywords}'
)
def write_into_output_file(worksheet, keyword_to_row_content):
for row in keyword_to_row_content.items():
worksheet.append(row)
def main():
root = tk.Tk()
root.title("Auswertung")
app = App(root)
app.pack()
app.mainloop()
if __name__ == "__main__":
main()
Code: Alles auswählen
def update_process(self):
try:
percent = self.process.get(block=False)
self.process_in_percent.set(f"{percent} %")
if percent != 100:
self.after(10, self.update_process)
else:
self.process_in_percent.set("Fertig!")
except Empty:
passCode: Alles auswählen
def update_process(self):
try:
percent = self.process.get(block=False)
except Empty:
pass
else:
self.process_in_percent.set(f"{percent} %")
if percent != 100:
self.after(10, self.update_process)
else:
self.process_in_percent.set("Fertig!")Code: Alles auswählen
def update_process(self):
try:
percent = self.process.get(block=False)
except Empty:
self.after(10, self.update_process)
else:
self.process_in_percent.set(f"{percent:.0f} %")
if percent != 100:
self.after(10, self.update_process)
else:
self.process_in_percent.set("Fertig!")Code: Alles auswählen
def update_process(self):
try:
percent = self.process.get(block=False)
except Empty:
pass
else:
if percent == 100:
self.process_in_percent.set("Fertig!")
return
self.process_in_percent.set(f"{percent:.0f} %")
self.after(10, self.update_process)Code: Alles auswählen
#!/usr/bin/env python3
import re
import tkinter as tk
from datetime import datetime
from pathlib import Path
from queue import Empty, Queue
from threading import Event, Thread
from tkinter import messagebox, ttk
from tkinter.filedialog import askdirectory
from openpyxl import Workbook, load_workbook
WORKBOOK_WITH_READ_DATA = "Ausgelesene Werte.xlsx"
INFO_FILE = "Nicht gelesene Dateien.txt"
DEFAULT_CELL_NAMES = "Volumen, Drehzahl, Gas"
class App(tk.Frame):
def __init__(self, master):
tk.Frame.__init__(self, master)
master.columnconfigure(0, weight=100)
self.user_select = tk.StringVar()
self.user_select.set("<Kein Oderne ausgewählt>")
ttk.Label(self, text="Ausgewählter Ordner:").grid(row=0, column=0, sticky=tk.W)
self.selected_folder = tk.Label(self, textvariable=self.user_select)
self.selected_folder.grid(row=1, column=0, sticky=tk.W)
ttk.Button(self, text="Ordner auswählen", command=self.open_dialog).grid(
row=2, column=0, sticky=tk.W
)
ttk.Label(self, text="Zellennamen die ausgelesen werden sollen").grid(
row=0, column=4, sticky=tk.W
)
ttk.Label(self, text="getrennt mit Komma eingeben:").grid(
row=1, column=4, sticky=tk.W
)
self.cells_to_read = tk.StringVar()
self.cells_to_read.set(DEFAULT_CELL_NAMES)
ttk.Entry(self, textvariable=self.cells_to_read).grid(
row=2, column=4, sticky=tk.W
)
ttk.Button(self, text="Auslesen", command=self.transfer_gui_data).grid(
row=5, column=5
)
ttk.Button(self, text="Beenden", command=self.stop_program).grid(
row=5, column=4, sticky=tk.E
)
self.process_in_percent = tk.StringVar()
ttk.Label(self, textvariable=self.process_in_percent).grid(row=4, column=4)
self.cancel = Event()
self.process = Queue()
self.folder_path = None
def open_dialog(self):
self.folder_path = Path(askdirectory(mustexist=True))
self.user_select.set(self.folder_path.name)
def on_progress(self, percentage):
self.process.put(percentage)
@staticmethod
def show_info_file_message(status):
if status:
messagebox.showinfo(
"Info Datei",
"Nicht alle gefundenen Dateien konnten gelesen werden, bitte Info-Datei beachten.",
)
def stop_program(self):
self.cancel.set()
self.quit()
def update_process(self):
try:
percent = self.process.get(block=False)
except Empty:
pass
else:
if percent == 100:
self.process_in_percent.set("Fertig!")
return
self.process_in_percent.set(f"{percent:.0f} %")
self.after(10, self.update_process)
def transfer_gui_data(self):
Thread(
target=control_program_sequence,
args=[
self.cells_to_read.get(),
self.folder_path,
self.cancel,
self.on_progress,
self.show_info_file_message,
],
).start()
self.update_process()
def control_program_sequence(
cells_to_read,
folder_path,
cancel,
on_progress=lambda percentage: None,
show_info_file_message=lambda status: False,
):
info_file = False
timestamp = datetime.now().strftime("%Y%m%d_%H%M")
keywords = keywords_to_list(cells_to_read)
workbook, output_file = open_output_file(timestamp, folder_path)
worksheet = workbook.active
files = collect_files(folder_path)
for number, filename in enumerate(files, 1):
if cancel.is_set():
break
on_progress(number / len(files) * 100)
keyword_to_row_content = read_excel_file(filename, keywords)
not_found_keywords = set(name.lower() for name in keywords) - set(
name.lower() for name in keyword_to_row_content
)
if not not_found_keywords:
write_into_output_file(worksheet, keyword_to_row_content)
else:
write_info_file(timestamp, folder_path, filename, not_found_keywords)
info_file = True
workbook.save(output_file)
if info_file:
show_info_file_message(True)
else:
show_info_file_message(False)
def collect_files(folder_path):
files = []
for file in folder_path.glob("**/*.xlsx"):
if file.name.split("_")[-1] != WORKBOOK_WITH_READ_DATA:
files.append(file)
return files
def find_keyword(description, keywords):
match = re.search(rf"\b({'|'.join(keywords)})\b", description, re.IGNORECASE)
if match:
return match.group(1)
return None
def keywords_to_list(cells_to_read):
return [keyword.strip() for keyword in cells_to_read.split(",")]
def open_output_file(timestamp, folder_path):
output_file = folder_path / f"{timestamp}_{WORKBOOK_WITH_READ_DATA}"
if output_file.exists():
workbook = load_workbook(output_file)
else:
workbook = Workbook()
return workbook, output_file
def read_excel_file(filename, keywords):
keyword_to_row_content = {}
worksheet = load_workbook(filename)["Tabelle1"]
for description, content in worksheet.iter_rows(min_col=1, max_col=2):
keyword = find_keyword(description.value, keywords)
if keyword is not None:
keyword_to_row_content[keyword] = content.value
return keyword_to_row_content
def write_info_file(timestamp, folder_path, file, not_found_keywords):
with (folder_path / f"{timestamp}_{INFO_FILE}").open(
"a", encoding="UTF-8"
) as info_file:
info_file.write(
f'-> In der Datei "{file}" wurden folgende Suchwörter nicht gefunden: {not_found_keywords}'
)
def write_into_output_file(worksheet, keyword_to_row_content):
for row in keyword_to_row_content.items():
worksheet.append(row)
def main():
root = tk.Tk()
root.title("Auswertung")
app = App(root)
app.pack()
app.mainloop()
if __name__ == "__main__":
main()
Code: Alles auswählen
pathlib.Path(__file__).parent.absolute()Das verstehe ich, dass das genau meine Aussage wiederlegt. Und __file__ der Pfad wäre, in dem meine exe-Datei liegt?In the bundled script, the PyInstaller bootloader always sets the __file__ variable inside the __main__ module to the absolute path inside the bundle directory, as if the byte-compiled entry-point script existed there.