JPEG image data into excel sheet

**sharmanjali87** · 09-30-2010, 04:29 AM

Hello friends,
I want to extract data from jpg image to excel sheet through macro.Can any one please guide me in the right direction to acheive this.Thanks in advance ..Any help will be appreciated

**teylyn** · 09-30-2010, 04:32 AM

Hello,

what do you mean with "extract data from jpg image to excel sheet"? What kind of data would you want to extract from the jpeg? Or do you want to insert an image into an Excel sheet?

Please explain.

**teylyn** · 09-30-2010, 04:34 AM

code to insert an image looks like

Please Login or Register  to view this content.

**sharmanjali87** · 09-30-2010, 04:44 AM

No...I don't want to insert image in spread sheet.Suppose some text is written in image i.e."how r u?" then i want to extract "how are u ?" from image and put it into cell1 of spread sheet.

**teylyn** · 09-30-2010, 04:48 AM

A jpeg is an image. Whatever is in that image is not extractable as a distinct unit.

Just as you cannot extract a tree or a face or any other part of the image, you can't extract text. It's just a bunch of compacted pixels.

**Andy Pope** · 09-30-2010, 04:52 AM

you would need to use some OCR software to attempt to extract text from image.

**sharmanjali87** · 09-30-2010, 05:00 AM

Thanks for your help.....one more ques i wanna to ask..Is there any other way to do this job...
If u know any please let me know ,it will be vry helpful to me...

**sharmanjali87** · 09-30-2010, 05:03 AM

Thanx Andy..I will search for that...

**johnjohns** · 09-30-2010, 05:24 AM

Yes, I too think the only option to extract text is using an OCR package. If you have MS office installed with all the components, use Microsoft Office Document Imaging. You may have to convert your jpeg to a TIF file (you can do it with MS paint)

rgds

johnjohns