Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 377
  • Last Modified:

Import and Read image data

I've imported an excel spreadsheet using cfspreadsheet into my mysql database and I didn't know there were images in the spreadsheet. Is there a way to read the images that were imported? And if so how would I go about doing it?
0
-Matthew-
Asked:
-Matthew-
  • 2
1 Solution
 
_agx_Commented:
Your "import" process is a little  hazy... I'm guessing each row contains a bunch of values plus a column with an embedded thumbnail image. So the question is can you extract the image for each row? AFAIK the answer is no, or not without difficulty.  If you just want all images, in no particular order, that might be doable.  Can you clarify?

CF has 0 functions for extracting images.  You can extract all images w/some java. BUT the thread below says images aren't stored within an actual cells and figuring out row, column positions is pretty complicated.

http://apache-poi.1045710.n5.nabble.com/A-newbie-question-how-to-get-image-position-td2294815.html

So in summary, extracting all images w/out positions may be doable. If you need their row and column positions afaik the answer is "no" or "not easily".
0
 
_agx_Commented:
Any updates on the requirements?
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now