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:

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.1.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.1-py3-none-any.whl (35.0 kB view details)

Uploaded Python 3

File details

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

File metadata

  • Download URL: saplist2pdf_sebastian_stigler-0.1.1.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.1.tar.gz
Algorithm Hash digest
SHA256 d350b3d5688cccf869df83ecb053f3cbb2e11960347900c4ced88be32163f9ac
MD5 4935ff82c7e4e76b665ab8c4833eaa7d
BLAKE2b-256 f3a8732fcca69d31954468af0e918dfe8666ef411ccee307377b15afe5a82a13

See more details on using hashes here.

File details

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

File metadata

  • Download URL: saplist2pdf_sebastian_stigler-0.1.1-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.1-py3-none-any.whl
Algorithm Hash digest
SHA256 747a27fe22e308904f5000a10acadff60bd0eb85645d8c7735bfcdd5f9edcce2
MD5 eeb24e2c28b1d1382b4c79630ce1b215
BLAKE2b-256 e4301fce54b006e44579b46523c747c4c1adcbc594e44ed6f1b3dfe7e1f56dee

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