Twine

PDF to XLSX - tested synthetic-data demo

Arindam Chatterjee
Published

0
  • Project creator

Self-initiated demonstration

AI-assisted software example, not a client commission. All input documents and values are synthetic.

What it does

Three generated AcroForm PDFs are mapped into one XLSX workbook using an explicit six-field schema. The implementation uses Node.js, pdf-lib and ExcelJS. It preserves leading-zero identifiers as text, numeric amounts, boolean checkboxes, blank values and multi-select arrays. Formula-looking and XML-like text is retained literally.

Evidence

The saved workbook was read back and checked against the expected values and types. Input and workbook SHA-256 hashes and a JSON verification receipt are retained. Four extraction regression tests passed. The image shows the actual synthetic workbook readback, not invented client results. The sample was tested locally on macOS.

Limits

No OCR, scanned/flattened/encrypted forms, XFA or high-volume production certification is claimed. A real project needs authorized representative files, an agreed field map, acceptance checks, scope, price and payment terms before work.

Prepared with GitHub Copilot assistance and checked with automated tests and visual review. No external client or collaborator delivery is claimed.