Bottom Page

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 Does XLRD have a method to extract embedded objects (pdf) from an excel sheet?
#1
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?
Quote
#2
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.
Quote

Top Page

Possibly Related Threads...
Thread Author Replies Views Last Post
  Python code to copy data from multiple workbooks into master sheet Fatman003 2 88 7 hours ago
Last Post: Fatman003
  An Object of Objects? cebb 4 204 Jul-28-2019, 03:29 PM
Last Post: cebb
  Bound method Uchikago 1 133 Jul-26-2019, 04:43 PM
Last Post: Gribouillis
  rotating and resizing objects jenya56 3 162 Jul-26-2019, 12:06 AM
Last Post: scidam
  What is the use of call method and when to use it? everyday1 1 112 Jul-14-2019, 01:02 PM
Last Post: ichabod801
  extract from strings some parts dervast 1 150 Jul-04-2019, 09:44 PM
Last Post: Axel_Erfurt
  Method not defined diskt 1 174 Jul-03-2019, 12:55 PM
Last Post: noisefloor
  iterate read data from excel sheet jp2017 1 204 Jun-19-2019, 07:45 PM
Last Post: micseydel
  Method not regocnized Lass86 3 241 Jun-19-2019, 09:03 AM
Last Post: Lass86
  Creating Dynamic Objects MacFie 4 329 Jun-13-2019, 02:48 PM
Last Post: MacFie

Forum Jump:


Users browsing this thread: 1 Guest(s)