Hey guys,
Im working with this script since weeks. Until today everything works fine. I
could open, read and modify cells without any problems. since this morning I
receive an error that says:
Traceback (most recent call last):
File "C:\Documents and Settings\USER\Desktop\Code\python\test_file.py", line
129, in <module>
EX = excel_com(ROOT, module_name, TEST_CHAPTER, TEST_DESCRIPTION,
Scope_defines)
File "C:\Documents and Settings\USER\_resources\libs\excel_lib.py", line 88,
in __init__
self.xlApp.Workbooks.open(r'C:\Documents and
Settings\USER\Testreport\FRT.xlsx')
File "C:\Python31\Lib\site-packages\win32com\client\__init__.py", line 462,
in __getattr__
raise AttributeError("'%s' object has no attribute '%s'" % (repr(self),
attr))
AttributeError: '<win32com.gen_py.Microsoft Excel 12.0 Object Library.Workbooks
instance at 0x16287504>' object has no attribute 'open'
what happened?
whats wrong with my code:
self.xlApp = Dispatch('Excel.Application')
self.xlApp.Visible = 1
self.xlApp.Workbooks.open(r'C:\Documents and
Settings\USER\Testreport\FRT.xlsx') #error here
pls help me!
-----------------------------------------------------------------
Mit freundlichen Grüßen / With kind regards
Benjamin Moll
________________________________________
Geschäftsführer/Managing Directors: Dr. Joji Murakami, Brendan Mc Kearney,
Satoru Yamaguchi, Yoshihiro Kawase
Sitz/Seat: Langen, Hessen; Registergericht/Commercial Register: Offenbach/Main
HRB 32725
________________________________________
This e-mail and any attachment contains information
which is private and confidential and is intended
for the addressee only. If you are not an addressee,
you are not authorised to read, copy or use the e-mail
or any attachment. If you have received this e-mail
in error, please notify the sender by return e-mail
and then delete it.
________________________________________
_______________________________________________
python-win32 mailing list
[email protected]
http://mail.python.org/mailman/listinfo/python-win32
