Paste an OCR to Excel

[Rick0825]

I used the OCR Wizard to grab some text. Text capture would not recognize the text. It looks like the code is

Code: Select all

OCRArea>390,417,480,446,strText

I then open an Excel file and need to paste to a cell. I was close to a solution by using

Code: Select all

MessageModal>strText

I could do a copy and paste from there but I would think their would be a better solution.
Thanks in advance for your help!

[Dorian (MJT support)]

To write to Excel you'd use the native Excel functions.

Let's start by creating and quitting a new test Excel file with XLCreate and XLQuit.

Run this first :

Code: Select all

//Create and Quit our Excel file
XLCreate>%script_dir%\MJT-test.xlsx,1,xlbook
XLQuit>xlbook

Now we can use XLOpen and XLSetCell to open the file and post the data. This posts to cell A5 in Sheet1 :

Code: Select all

OCRArea>390,417,480,446,strText
XLopen>%script_dir%\MJT-test.xlsx,1,xlbook
XLSetCell>xlbook,Sheet1,1,5,strText,res

It might also be worth your time to visit the Excel section in the manual just to familiarize yourself with the Excel functions.

[Rick0825]

Works great. Such a learning curve, but im getting their.
Thanks again.