Skip to main content

Convert DepEd OCR PDFs to Excel.

Project description

DepEdPDFtoExcel

Convert DepEd OCR PDFs to Excel using Ghostscript + Tesseract OCR.

Requirements

  • Python 3.9+
  • Ghostscript (for PDF to image conversion)
  • Tesseract OCR

Quick start

python -m pip install -r requirements.txt
python ocr_to_excel.py

Automated dependency install (Windows)

This script installs Ghostscript and Tesseract using winget.

Set-ExecutionPolicy -Scope Process -ExecutionPolicy Bypass
./scripts/install_dependencies.ps1

Optional: set user env vars after install (paths may vary by version):

./scripts/install_dependencies.ps1 -SetEnv

If winget is missing, install App Installer from Microsoft Store and retry.

Environment variables

  • TESSERACT_CMD - path to tesseract.exe (optional)
  • GS_PATH - path to gswin64c.exe (optional)
  • OCR_DPI - image DPI (default 300)
  • CROP_TOP_RATIO - top crop ratio (default 0.2)
  • CROP_BOTTOM_RATIO - bottom crop ratio (default 0.9)

Output

Generated Excel files are placed in outputs/excel/.

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

ocr_to_excel-0.1.2.tar.gz (9.6 kB view details)

Uploaded Source

Built Distribution

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

ocr_to_excel-0.1.2-py3-none-any.whl (9.1 kB view details)

Uploaded Python 3

File details

Details for the file ocr_to_excel-0.1.2.tar.gz.

File metadata

  • Download URL: ocr_to_excel-0.1.2.tar.gz
  • Upload date:
  • Size: 9.6 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.12.6

File hashes

Hashes for ocr_to_excel-0.1.2.tar.gz
Algorithm Hash digest
SHA256 07f7c338f544e4ad4185b6b2218db0ae6b1752dc4bcd2e70fdc454786db93cb9
MD5 92a7687d2e3c33d0d950e6638bb9dc20
BLAKE2b-256 f5703db6b3892a7101461b06a9fe5df0a027ae663146a5cf356b6e91430d1d3c

See more details on using hashes here.

File details

Details for the file ocr_to_excel-0.1.2-py3-none-any.whl.

File metadata

  • Download URL: ocr_to_excel-0.1.2-py3-none-any.whl
  • Upload date:
  • Size: 9.1 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.12.6

File hashes

Hashes for ocr_to_excel-0.1.2-py3-none-any.whl
Algorithm Hash digest
SHA256 3e75bd4ddb5959cfea76950ca33baff0ae228eba2a4dbe296b385b45eb627311
MD5 39e17892560c01504161736a8eee0b08
BLAKE2b-256 ad703c1a7f3485e96ce8473e0078cd19c910944921789a26ee9f1a00d6cc0d3d

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