View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Martin Brown Martin Brown is offline
external usenet poster
 
Posts: 230
Default Importing a JPEG image to excel as matrix

On 17/07/2011 11:59, Dave Peterson wrote:
You may be able to use your scanner's OCR program if it can read .jpg
files.

If it can't, maybe you could print it and then scan it and then use the
OCR program.

Either way, I'd invest a lot of time checking that data. I've never seen
an OCR program that was 100% accurate.



On 07/16/2011 14:50, qia li wrote:
HI guys,
Is there a way to convert a JPEG image into a matrix of integers (code
index)?

Thanks


The question as posed is ambiguous, but assuming the OP wants to load
the red, green and blue components of a JPEG image into Excel then the
simple answer is no. The slightly longer answer is to save the JPEG file
as a windows BMP file and then load that image into Excel.

XL2003 and earlier the shortest dimension must be < 256.
XL2007 removes this limitation but will be glacially slow.

Regards,
Martin Brown