
Learn to build an OCR-driven workflow that extracts tables from a PDF into Excel, using Google Colab, a FastAPI API, and a zip output containing per-page Excel sheets.
Outline the high level system using PaddleOCR to convert pdf tables into an Excel file by splitting pages and applying text detection, table structure prediction, and text recognition.
Demonstrate an end-to-end pdf to excel workflow by installing paddle and paddle OCR, installing pdf to image with poppler utilities, then extracting tables into xlsx files.
Extract text and table data from each PDF page image by reading the image and using the PPE structure to save results as text and Excel sheets per page.
Build a FastAPI based PDF to Excel API by installing Python, creating a virtual environment, and defining endpoints, core logic, and schemas. Run with uvicorn and use docs to test.
Learn to build a simple API that accepts a PDF upload, validates PDF files, converts pages to images, extracts tables, saves results, and returns a zip archive via FastAPI.
Test the solution using Postman, comparing GET and POST requests for API interaction, and validating PDF input. Save OCR-driven table extraction results to output folders and Excel sheets.
We demonstrate a pdf to excel system that converts a pdf into excel sheets with tables; explore courses in computer vision, natural language processing, image generation, and linear algebra.
Optical Character Recognition (OCR) systems are used in diverse industries today. With the development of better performing deep learning models, we are getting even better OCR solutions.
In this course, we shall take you on an amazing journey in which you'll implement and deploy a working OCR solution. To be more precise we shall build a working solution in which a user inputs a PDF file and gets all the tables contained in the PDF as excel sheets. We'll start from understanding how this system works, then build a working prototype on Google Colaboratory (Colab). From here, we shall build a simple API with the Fastapi framework. This will permit users input a PDF file and get as output a compressed file containing folders which themselves contain excel sheets with the different tables found in the PDF.
If you are willing to move a step further in your career, this course is destined for you and we are super excited to help achieve your goals!
This course is offered to you by Neuralearn. And just like every other course by Neuralearn, we lay much emphasis on feedback. Your reviews and questions in the forum will help us better this course. Feel free to ask as many questions as possible on the forum. We do our very best to reply in the shortest possible time.
Enjoy!!!