PureBoard

Code: Alles auswählen

from tkinter import filedialog
from tkinter.filedialog import askopenfilename
from tkinter.filedialog import asksaveasfilename
from sys import exit
import openpyxl
import pandas as pd

if filename1 := askopenfilename(title="Choose Excel File", filetypes=[("Excel Files","*.xlsx"), ("Excel Files","*.xls")]):
    read_file = pd.read_excel (filename1)
else:
    exit()
f = filename1.split("/")[-1].split(".")[0]
if filename2 := filedialog.asksaveasfilename(initialfile = f, defaultextension=".csv", title="Save CSV File", filetypes=[("CSV File","*.csv")]):
    read_file.to_csv (filename2, index = None, header=True)
else:
    exit()
exit()