Python Forum
Does XLRD have a method to extract embedded objects (pdf) from an excel sheet?
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?
Reply
#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.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Selecting correct xlrd version Kithsiri 4 446 Feb-27-2024, 07:09 AM
Last Post: Kithsiri
  Int.From_Bytes Method - Conversion of Non-Escaped Bytes Objects new_coder_231013 1 270 Jan-17-2024, 09:13 PM
Last Post: Gribouillis
  Python and pandas: Aggregate lines form Excel sheet Glyxbringer 12 1,696 Oct-31-2023, 10:21 AM
Last Post: Pedroski55
  how to read txt file, and write into excel with multiply sheet jacklee26 14 9,515 Jan-21-2023, 06:57 AM
Last Post: jacklee26
  Reading Excel file and use a wildcard in file name and sheet name randolphoralph 6 6,857 Jan-13-2022, 10:20 PM
Last Post: randolphoralph
  Python script for excel sheet Nabil 4 3,224 Jun-01-2021, 05:09 AM
Last Post: Pedroski55
  Add a new column when I extract each sheet in an Excel workbook as a new csv file shantanu97 0 2,191 Mar-24-2021, 04:56 AM
Last Post: shantanu97
  Append excel sheet using openpyxl TammyP 1 2,314 Feb-02-2021, 06:32 PM
Last Post: nilamo
  How to Copy Single Value From One Excel Sheet to Another SunWers 4 4,199 Dec-29-2020, 05:39 PM
Last Post: SunWers
  Extract data from PDF page to Excel nathan_nz 1 2,654 Oct-29-2020, 08:04 PM
Last Post: Larz60+

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020