Python webuntis-xlsx-reformatting-tool

1. Purpose

This tool is designed to transform Excel files into a more readable format, with columns for 'Subject,' 'Info,' and 'Date' in German.

2. Default WebUntis-calender download result

September	Oktober	November	Dezember	Januar	Februar	März	April	Mai
				Example Test
					Example Test
				Example Test

3. Optimized reformatter-tool output

Fach	Info	Datum
Englisch	Schularbeit	24/10/2023
Englisch	Schularbeit	14/11/2023
Mathe	Schularbeit	17/11/2023
Deutsch	Schularbeit	24/11/2023
Wirtschaft	Test	28/11/2023

4. How to run

4.1. Running manually

• Install the following libraries:

  • pip install tk

  • pip install numpy

  • pip install pandas

  • pip install openpyxl

  • pip install xbrl

  • pip install xlrd

• Run the script

  • python webuntis-reformatting-tool.py

• Select the WebUntis-calender file

• Select the previously created output-XLSX-file

4.2. Running automatically (.exe-file)

• Download your WebUntis-list

• Start the webuntis-reformatting-tool.py.exe file

• Select the WebUntis-list file

• Select a location for the output-file

• Tada! Have fun with your formatted data

4.3. Create an .exe-file manually

• Follow the manual-installation guideline

• Install:

  • pip install pyinstaller

• Build exe file:

  • cd webuntis-reformating-tool

  • pyinstaller webuntis-reformatting-tool.py --onefile

• The .exe should be in /dist/…​