saplist2pdf

Convert the SAP Excel list into a formatted PDF.

Requirements

• Python 3.11 or newer
• A SAP export in Excel format with the expected columns

Install

With pip

Create a virtual environment first, then install the project:

python -m venv .venv
source .venv/bin/activate
pip install saplist2pdf-sebastian-stigler

Usage

After installation, the command line tool is available as saplist2pdf.

saplist2pdf input.xlsx

By default, the PDF is written to teilnehmerliste_XX.pdf where XX is a two-digit number.

The command now supports different entries in the Studienfach column and creates a new PDF file for each distinct Studienfach entry.

Options

• -o, --output: set a custom output filename
• --check: validate the Excel file without creating a PDF
• --version: print the installed version

Examples

• Create a PDF with a custom name:

  saplist2pdf input.xlsx -o output.pdf
  

  This creates output_XX.pdf (see Usage above).

• Validate the spreadsheet before generating the PDF:

  saplist2pdf input.xlsx --check
  

Expected input

The Excel file must contain at least one row and these columns:

• Modultitel
• Leistungsnummer
• Name der Prüfung
• Bezugsobjekt
• Prüfender
• Semester
• Studienfach
• Matrikelnummer
• Name
• Versuch

Furthermore, it is expected, that the all rows for the columns mentioned above, except the last three, are the same.