montecas Posted October 3, 2006 Posted October 3, 2006 Hey everyone, I am trying to write a script to grab data from one window specifically a program used at work to display the sales from the day, and then input that data into an excel workbook. I have no idea where to begin, any help would be greatly appriciated!
Kickassjoe Posted October 3, 2006 Posted October 3, 2006 Search the scripts and scrapts forum for "OCR" (without the quotes) What goes around comes around... Payback's a bitch.
Thatsgreat2345 Posted October 3, 2006 Posted October 3, 2006 is it in text or picture format and there is an excel UDF in scripts and scraps
Confuzzled Posted October 5, 2006 Posted October 5, 2006 What is the program that displays the sales called? Does it have a particualr layout on the screen or a report writer interface? Does it use a web browser to see the results? Does it support C.O.M.? You may be able to 'screen scrape' the contents and paste into Excel or pass it through an intermediatary file in something like CSV format.
montecas Posted October 5, 2006 Author Posted October 5, 2006 The program is a propriety sales tracker, it runs in a comand prompt window.
Xenobiologist Posted October 5, 2006 Posted October 5, 2006 The program is a propriety sales tracker, it runs in a comand prompt window.Hi,take Autoit Window Info to check whether you can read the text.So long,Mega Scripts & functions Organize Includes Let Scite organize the include files Yahtzee The game "Yahtzee" (Kniffel, DiceLion) LoginWrapper Secure scripts by adding a query (authentication) _RunOnlyOnThis UDF Make sure that a script can only be executed on ... (Windows / HD / ...) Internet-Café Server/Client Application Open CD, Start Browser, Lock remote client, etc. MultipleFuncsWithOneHotkey Start different funcs by hitting one hotkey different times
Skizmata Posted July 4, 2007 Posted July 4, 2007 (edited) Hi,take Autoit Window Info to check whether you can read the text.So long,MegaWhat if you can read the text how would you then get it? I need something similar to read a string of numbers out of an AS400 Emulator for work. I need to be able to pull a number from the screen add it to a number I enter in the program and put it back in place of the number I took from the screen.Thanks,-Skizmata Edited July 4, 2007 by Skizmata AutoIt changed my life.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now