PDF to Excel Script Revamp

Заказчик: AI | Опубликовано: 15.04.2026

My Excel workbook already contains a VBA macro that opens a PDF, extracts targetted numeric value from certain columns, aggregates them, and drops the results straight into specific cells. Functionally it works, yet it generates errors when it comes accross different number formats. I need a fast, tidy rewrite (or smart port) that does the same three core steps—read, parse & aggregate, write—within roughly three hours of coding time. You can choose the approach that lets you move fastest: streamline the existing VBA, replace it entirely with a Python routine built around pdfplumber, or create a hybrid where Python performs the heavy lifting and VBA simply updates the sheet. I’m comfortable with any of those paths as long as the final workbook remains a one-click solution. Key goals • Recognise both European “1.234,56” and North-American “1,234.56” formats without confusion • Add solid error handling so corrupted PDFs or missing fields never crash the workbook • Deliver noticeably better performance on a 30-page PDF than the current macro • Produce a concise execution log (text file or hidden sheet) capturing start/end time, pages processed, and anomalies Deliverables 1. Refactored, fully commented code dropped into the workbook (and, if Python is used, the .py file) 2. A brief README covering setup and use 3. Proof of success on my sample PDF (screenshot or short clip) I’ll supply the original workbook and a representative PDF as soon as we start. Please respond only if you can tackle and complete the work in a single session of less than three hours—speed and accuracy are both critical on this one.