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
  Int.From_Bytes Method - Conversion of Non-Escaped Bytes Objects new_coder_231013 2 3,941 Apr-06-2024, 04:24 PM
Last Post: new_coder_231013
  Selecting correct xlrd version Kithsiri 4 6,268 Feb-27-2024, 07:09 AM
Last Post: Kithsiri
  Python and pandas: Aggregate lines form Excel sheet Glyxbringer 12 7,665 Oct-31-2023, 10:21 AM
Last Post: Pedroski55
  how to read txt file, and write into excel with multiply sheet jacklee26 14 20,533 Jan-21-2023, 06:57 AM
Last Post: jacklee26
  Reading Excel file and use a wildcard in file name and sheet name randolphoralph 6 16,119 Jan-13-2022, 10:20 PM
Last Post: randolphoralph
  Python script for excel sheet Nabil 4 5,728 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 3,229 Mar-24-2021, 04:56 AM
Last Post: shantanu97
  Append excel sheet using openpyxl TammyP 1 4,185 Feb-02-2021, 06:32 PM
Last Post: nilamo
  How to Copy Single Value From One Excel Sheet to Another SunWers 4 9,811 Dec-29-2020, 05:39 PM
Last Post: SunWers
  Extract data from PDF page to Excel nathan_nz 1 5,593 Oct-29-2020, 08:04 PM
Last Post: Larz60+

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020
This forum uses Lukasz Tkacz MyBB addons.
Forum use Krzysztof "Supryk" Supryczynski addons.