Importing a JPEG image to excel as matrix
 

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

Thanks

Importing a JPEG image to excel as matrix
 

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

--
Dave Peterson

Importing a JPEG image to excel as matrix
 

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



On Jul 17, 11:59*am, 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

--
Dave Peterson

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

Importing a JPEG image to excel as matrix
 

On Jul 17, 1:32*pm, Martin Brown
wrote:
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

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