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
  help with changing values in an excel sheet and saving to a new file Moneyman212 2 144 Nov-19-2019, 06:25 AM
Last Post: Moneyman212
  Loop through folder of Excel Files and extract single column fioranosnake 2 128 Oct-28-2019, 05:19 PM
Last Post: fioranosnake
  How to extract a matrix from .xml.gz file to a excel file or any other output? enyrb 0 104 Oct-21-2019, 01:01 PM
Last Post: enyrb
  XLRD Package not be able to call dhiliptcs 2 147 Sep-24-2019, 05:21 PM
Last Post: dhiliptcs
  ImportError: No module named xlrd dhiliptcs 5 970 Sep-21-2019, 12:17 PM
Last Post: brighteningeyes
  iterate read data from excel sheet jp2017 1 362 Jun-19-2019, 07:45 PM
Last Post: micseydel
  Help | float to Int in xlrd Vinci141 0 541 May-13-2019, 07:00 AM
Last Post: Vinci141
  Run macros of excel sheet from python scripts shubhamjainj 3 2,093 May-01-2019, 08:40 AM
Last Post: buran
  How to obtain the background color of a cell using xlrd? Krszt 1 2,544 Mar-12-2019, 11:23 PM
Last Post: hshivaraj
  Iterate over excel-sheets using xlrd tobbs 6 3,143 Feb-28-2019, 08:33 PM
Last Post: tobbs

Forum Jump:


Users browsing this thread: 1 Guest(s)