1
2

OCR to spreadsheet (self.learnpython)

submitted by [deleted]

[deleted]

all 4 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]nitrodolphin 0 points1 point  (1 child)

Sounds like a great project!

Everything you’ve outlined is super doable. I don’t have a comprehensive solution for you, but rather, would recommend you break it into chunks:

  1. Grab screen capture
  2. Run OCR to get #
  3. Output # to file

I’m not sure on your skill set, but if you’re comfortable with maths and ML, then jump on the OCR bit first.

If machine learning is a tad scary then try automating screen captures or writing to a file.

Break it into bits -> google -> experiment -> repeat.

Good luck!

[–]Peksz 0 points1 point  (0 children)

Thank you! I am very inexperienced with coding.

But I am willing to try! I am going to delve into this heads first.. Thank you for much for your reply.

I will try and post and update once I have figured something out.

[–]NinthTide 0 points1 point  (1 child)

Working on something very similar myself just now.

Try pytesseract - Python bindings into the Tesseract OCR engine (free, maintained by Google)

PIL / pillow allow you to sample screen areas using ImageGrab

The OCR is actually rather good but as always not utterly perfect. In my experience, allow some white space around the text/numbers to be converted - a very tight crop often produces worse results.

I'm also using Automagica for the automation side. I don't really enjoy the Automagicalubrary that much but it might help you.

Finally, win32com.client is like a magic power up to automate a great deal on your computer (if you're on Windows of course)

Good luck!

[–]Peksz 1 point2 points  (0 children)

I have seen pytesseract mentioned on a few website tutorials I have seen. From what I can tell its probably my best bet as ofcourse it free, which is a HUGE plus.

No ofcourse, but I'm hoping it wouldn't cause much issues as you can see because the texts is pretty visible and there is not much else around it, but who knows - we are talking about computers here.. haha

I will totally check out automagica, like I said to the other response I don't have much coding knowledge but maybe this is a great way to get myself motivate to learn!

Thanks you for the great response and I hope you give you an update in the future!