Clark's Tech Blog

#!/usr/bin/python
 
# Types data from Excel into a Windows app.
 
import sys, string, time
from appscript import *
 
 
def typestring(s):
    # Types string s using GUI scripting
 
    for i in range(0,len(s)):
        c = s[i]
        if c in string.ascii_uppercase:
            app(u'System Events').keystroke(s[i], using=k.shift_down)
        else:
            app(u'System Events').keystroke(s[i])
        #print s[i]
 
def backtab():
    # Tab backwards
    app(u'System Events').keystroke("\t", using=k.shift_down)
 
def tab():
    # Tab forward
    app(u'System Events').keystroke("\t")
 
def cr():
    # Carriage Return
    app(u'System Events').keystroke(u'\r')
 
def main():
    MS = app('/Applications/Microsoft Office 2008/Microsoft Excel')
    PD = app(u'Parallels Desktop')
 
    PD.activate()
 
    # get the current row in Excel
    row = MS.selection.first_row_index.get()
 
    # date
    data = MS.cells[ "A" + str(row) ].value.get()
    s = data.strftime("%m/%d/%y")  # convert date to string
    typestring(s)
 
    tab() # to check number
 
    tab() # to payee
 
    data = MS.cells[ "C" + str(row) ].value.get()
    typestring(data)
 
    tab() # to payment
 
    data = MS.cells[ "B" + str(row) ].value.get()
    s = str(data)
    typestring(s)
 
    cr()
 
    # advance to next row in Excel
    MS.rows[row+1].select()
 
if __name__ == '__main__':
 
	main()
 
    # change to 0 for success, 1 for (partial) failure
	sys.exit(0)