occasional win32com error

[Ransom]

Hey folks...

Newbie here. I'm working with win32com launching, closing and
re-launching Excel grabbing output and doing stuff.

Well, on some occasions, I get the following error:
Traceback (most recent call last):
File "checkrates.py" , line 95, in ?
newdata = getNewData(test cases1)
File "checkrates.py" , line 62, in getNewData
excel.Workbooks .Open(docdir + 'TOSrat2006_09. xls')
File "C:\Python24\li b\site-packages\win32c om\client\dynam ic.py", line
496, in __getattr__
raise AttributeError, "%s.%s" % (self._username _, attr)
AttributeError: Excel.Applicati on.Workbooks

Sometimes the code runs fine. Sometimes I get this error. The code in
question is:

import string
from win32com.client import Dispatch
docdir = 'E:\\scripts\\P ython\\RSAutoma tion\\'
def getOldData(test cases):
#open excel
excel = Dispatch("Excel .Application")
excel.Workbooks .Open(docdir + 'TOSrat2006_07. xls')

oldoutputlist = []
for rsinput in testcases.xread lines():

inputlist = string.split(rs input, ',')

# iterate through and update spreadheet input
cellx = range(3,51)
values = range(0,48)
for i,r in zip(cellx, values):

excel.ActiveShe et.Cells(i,2).V alue = inputlist[r]

#read spreadsheet output and cat to outputlist
premium = excel.ActiveShe et.Cells(32,6). Value
oldoutputlist.a ppend(premium)
# close up excel
excel.ActiveWor kbook.Close(Sav eChanges=0)
excel.Quit()
del excel
return oldoutputlist

def getNewData(test cases):
# open excel
excel = Dispatch("Excel .Application")
excel.Workbooks .Open(docdir + 'TOSrat2006_09. xls')
newoutputlist = []
for rsinput in testcases.xread lines():

inputlist = string.split(rs input, ',')

# iterate through and update spreadsheet input
cellx = range(3,51)
values = range(0,48)
for i,r in zip(cellx, values):

excel.ActiveShe et.Cells(i,2).V alue = inputlist[r]

# read ratesheet output and cat to outputlist
premium = excel.ActiveShe et.Cells(32,6). Value
newoutputlist.a ppend(premium)
excel.ActiveWor kbook.Close(Sav eChanges=0)
excel.Quit()
del excel
return newoutputlist

if __name__ == "__main__":
testcases = open('arse_test cases.csv','r')
testcases1 = open('arse_test cases.csv','r')
olddata = getOldData(test cases)
newdata = getNewData(test cases1)

print olddata
print newdata
It seems like Python or COM is having a hard time freeing up (or
closing down) excel prior to the "getNewData " function running and it
is stepping on itself. I thought the stuff I'm doing at the end of
getOldData should successfully shut down excel.

Any advice, criticism, flames are appreciated.

Cheers!

[Roger Upole]

You could try using DispatchEx to make sure you always
get a new instance of Excel.

Roger

"Ransom" <gy***@sbcgloba l.net> wrote in message news:11******** **************@ f6g2000cwb.goog legroups.com...

Hey folks...

Newbie here. I'm working with win32com launching, closing and
re-launching Excel grabbing output and doing stuff.

Well, on some occasions, I get the following error:
Traceback (most recent call last):
File "checkrates.py" , line 95, in ?
newdata = getNewData(test cases1)
File "checkrates.py" , line 62, in getNewData
excel.Workbooks .Open(docdir + 'TOSrat2006_09. xls')
File "C:\Python24\li b\site-packages\win32c om\client\dynam ic.py", line
496, in __getattr__
raise AttributeError, "%s.%s" % (self._username _, attr)
AttributeError: Excel.Applicati on.Workbooks

Sometimes the code runs fine. Sometimes I get this error. The code in
question is:

import string
from win32com.client import Dispatch
docdir = 'E:\\scripts\\P ython\\RSAutoma tion\\'
def getOldData(test cases):
#open excel
excel = Dispatch("Excel .Application")
excel.Workbooks .Open(docdir + 'TOSrat2006_07. xls')

oldoutputlist = []
for rsinput in testcases.xread lines():

inputlist = string.split(rs input, ',')

# iterate through and update spreadheet input
cellx = range(3,51)
values = range(0,48)
for i,r in zip(cellx, values):

excel.ActiveShe et.Cells(i,2).V alue = inputlist[r]

#read spreadsheet output and cat to outputlist
premium = excel.ActiveShe et.Cells(32,6). Value
oldoutputlist.a ppend(premium)
# close up excel
excel.ActiveWor kbook.Close(Sav eChanges=0)
excel.Quit()
del excel
return oldoutputlist

def getNewData(test cases):
# open excel
excel = Dispatch("Excel .Application")
excel.Workbooks .Open(docdir + 'TOSrat2006_09. xls')
newoutputlist = []
for rsinput in testcases.xread lines():

inputlist = string.split(rs input, ',')

# iterate through and update spreadsheet input
cellx = range(3,51)
values = range(0,48)
for i,r in zip(cellx, values):

excel.ActiveShe et.Cells(i,2).V alue = inputlist[r]

# read ratesheet output and cat to outputlist
premium = excel.ActiveShe et.Cells(32,6). Value
newoutputlist.a ppend(premium)
excel.ActiveWor kbook.Close(Sav eChanges=0)
excel.Quit()
del excel
return newoutputlist

if __name__ == "__main__":
testcases = open('arse_test cases.csv','r')
testcases1 = open('arse_test cases.csv','r')
olddata = getOldData(test cases)
newdata = getNewData(test cases1)

print olddata
print newdata
It seems like Python or COM is having a hard time freeing up (or
closing down) excel prior to the "getNewData " function running and it
is stepping on itself. I thought the stuff I'm doing at the end of
getOldData should successfully shut down excel.

Any advice, criticism, flames are appreciated.

Cheers!

----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---