+ Reply to Thread
Results 1 to 5 of 5

Converting .jif,.png.jpg images data into excel for editing

  1. #1
    Registered User
    Join Date
    05-07-2012
    Location
    Delhi
    MS-Off Ver
    Excel 2003 and Excel 2007
    Posts
    62

    Converting .jif,.png.jpg images data into excel for editing

    Hi All,

    From last one week I am struggling with one problem.
    I have data available in image and would like to use that data in excel for further calculations.

    For example:

    I have created a excel sheet of students marks:

    Student Science Maths English Civic Biology Physics Total

    Shekhar 55 78 71 68 76 74 422
    Hari 59 68 78 71 73 69 418
    Nihal 76 58 82 67 59 73 415
    Kewal 83 75 73 68 63 67 429

    After taking a print out I have removed the excel from my computer and now have to edit some scores in the list.
    To avoid creating another data set, I have scanned this document and convert it in .PNG (file).
    Now I would like to use this .PNG file in excel by extracting entire data from picture image in excel cells for further editing.


    Can somebody help me by doing this via VBA or VB?
    Let me know if any other detail required apart from uploading the file, as I have some restrictions of uploading any file.

    Thanks in advance.
    Shekhar Sharma
    Please click on the * if resolution works for you

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Converting .jif,.png.jpg images data into excel for editing

    You're going to need to ocr software, have a google around for it. You can't do this in Excel alone

  3. #3
    Registered User
    Join Date
    05-07-2012
    Location
    Delhi
    MS-Off Ver
    Excel 2003 and Excel 2007
    Posts
    62

    Re: Converting .jif,.png.jpg images data into excel for editing

    Hi,

    Thanks for the reply, however I am looking forward to complete this exercise only with Excel programming.

    All suggestions are welcome

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Converting .jif,.png.jpg images data into excel for editing

    Then good luck, but it isn't going to happen. Excel is a lot of things, but OCR software it aint

  5. #5
    Registered User
    Join Date
    04-24-2013
    Location
    orange
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Converting .jif,.png.jpg images data into excel for editing

    you can try this image converter , ithink it might be helpful , good luck .

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1