Importing a JPEG image to excel as matrix

Q

qia li

HI guys,
Is there a way to convert a JPEG image into a matrix of integers (code
index)?

Thanks
 
D

Dave Peterson

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.
 
Q

qia li

I am actually trying to write a OCR program in excel, but as the first
step I need to import the image into my program, individual point and
the corresponding color index.
Anyone could advise?
Thanks
 
M

Martin Brown

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.

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
 
Q

qia li

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

Thanks, I am trying to load the red green and blue components into
Excel. If it is BMP file, Could you pls advise how i could load it
into Excel?

Thanks

Allen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top