title: How do I control excel through python so that I can use the "get data from pdf" feature of excel?
body: <p>I am working on an script that takes input from a pdf file, extracts text and data from it which can then be used by my python application. I tried a couple of python modules that allow me to extract text from pdfs but the excel get data from pdf does this way better. It also formats the data from the pdf into tables. Currently I have to open up excel, do get data from pdf and then save the table as an excel file which python can then access. I would like to automate this so that when I run the python script, it automatically does get data from pdf through excel. Whats the best way to aicheve that?</p>