Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 420
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.programming
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
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert any documents(Word, Excel) into BMP, GIF, JPEG, PNG and TIFF image [email protected] Charts and Charting in Excel 2 August 6th 13 04:07 AM
how do I place an image (jpeg) onto an Excel worksheet? Sanjo Excel Worksheet Functions 1 August 31st 08 01:47 AM
Convert any documents(Word, Excel) into BMP, GIF, JPEG, PNG and TIFF image [email protected] Excel Programming 0 August 23rd 07 08:00 AM
Importing an Image (jpeg) in Excel Hubert Rétif Excel Programming 1 June 8th 05 01:24 PM
UserForm as a Jpeg Image John[_78_] Excel Programming 7 February 19th 04 11:46 AM


All times are GMT +1. The time now is 10:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"