At the end of every month, there is a task that I always dread. Gathering numbers from multiple Excel files, copying them into a single summary sheet, converting it to PDF, and sending it via email.

Public-safe version of a document automation toolkit built to read scanned financial PDFs, clean OCR output, extract structured information and reconcile spreadsheet rows with their corresponding PDF ...

Have you ever heard the term "work automation"? Routine Excel tasks can be re-executed with zero errors every time once coded. In this series, we will build up "Excel automation for the workplace" in ...

pyexcel-xlsx is a tiny wrapper library to read, manipulate and write data in xlsx and xlsm format using read_only mode reader, write_only mode writer from openpyxl. You are likely to use it with ...

Converting large paper-based data into a spreadsheet is arguably the most mundane of tasks. In an era where AI can make Donald Trump sing a Taylor Swift song with perfect vocals, the manual drudgery ...