python - Automation: reading certain part of multiple PDFs and adding the text found to a XLS document?

Question

I want to learn how to write a script (maybe in Python, but anything easier will do) that is able to read a text string inside a PDF (text selectable ones), and inside this PDF, this text string always comes up after certain text.

So, after the script has found the string, I need it to add this content to the next available line in a Excel/Calc document.

What am I looking at here? I suppose there's a python library that reads text PDFs and interacts with XLS documents, right? So how do I start writing something that is able to locate the text, in a same line, that comes after another repeated string of text (I have hundreds of these PDFs)?

Also, there's the interaction with the interaction with the XLS document. How can I make this script add the found content to this document without messing with the content that's already there (in other words, just adding it to the next line).

Thanks a lot.

question from:https://stackoverflow.com/questions/65844837/automation-reading-certain-part-of-multiple-pdfs-and-adding-the-text-found-to-a

Answer 1

Waitting for answers