+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Does XLRD have a method to extract embedded objects (pdf) from an excel sheet? (/thread-19106.html)
Does XLRD have a method to extract embedded objects (pdf) from an excel sheet? - matthewme - Jun-13-2019
I am using xlrd to pull excel sheet data into a sqlite database. In some excel sheets we want our users to attach PDFs. I haven't been able to find a way to extract the PDF and place it into database as a BLOB datatype. Is there anyway that I can achieve this?
RE: Does XLRD have a method to extract embedded objects (pdf) from an excel sheet? - Larz60+ - Jun-13-2019
Please show excel format.
You ask for attached pdf's, are there stored externally?
Pdf's can be embedded into an sqlite3 database as blobs, but it's more efficient to store them externally
and to have a file path stored in the database, rather than the pdf itself.
You may want to look into using pandas as an alternative.