Skip to main content

Convert the excel list from sap to a pdf

Project description

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 in editable mode:

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.pdf.

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

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.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

saplist2pdf_sebastian_stigler-0.1.0.tar.gz (34.7 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

saplist2pdf_sebastian_stigler-0.1.0-py3-none-any.whl (35.0 kB view details)

Uploaded Python 3

File details

Details for the file saplist2pdf_sebastian_stigler-0.1.0.tar.gz.

File metadata

  • Download URL: saplist2pdf_sebastian_stigler-0.1.0.tar.gz
  • Upload date:
  • Size: 34.7 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: uv/0.10.4 {"installer":{"name":"uv","version":"0.10.4","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"22.04","id":"jammy","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}

File hashes

Hashes for saplist2pdf_sebastian_stigler-0.1.0.tar.gz
Algorithm Hash digest
SHA256 52efedced7d8b5db9af59f8ed39e19176816accd9f59e80f1fe8f112987590f3
MD5 3148449459ac10da55b43b530b232d86
BLAKE2b-256 7c3ce1a905d4426fb6c27788b2fa723412ccd48af5494c6205b7b22f2410597e

See more details on using hashes here.

File details

Details for the file saplist2pdf_sebastian_stigler-0.1.0-py3-none-any.whl.

File metadata

  • Download URL: saplist2pdf_sebastian_stigler-0.1.0-py3-none-any.whl
  • Upload date:
  • Size: 35.0 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: uv/0.10.4 {"installer":{"name":"uv","version":"0.10.4","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"22.04","id":"jammy","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}

File hashes

Hashes for saplist2pdf_sebastian_stigler-0.1.0-py3-none-any.whl
Algorithm Hash digest
SHA256 737ae8f2963f64efb3b47de313ce875594b73823ed20dc8fe8d197075be27612
MD5 289c41ef9ff917230f1577b355acedfc
BLAKE2b-256 0af091f96ff6bc69da1284bf34186d97d324524f531dcf7c623d558aa50ae286

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page