search

HDFGroup / PyHexad

A PyXLL-based Excel add-in for HDF5
Other
9 stars 2 forks source link

I don't understand when an asynchronous call is made. #30

Closed gheber closed 9 years ago

gheber commented 9 years ago

Need to discuss w/ Didrik.

The log is littered with exception like this:

2014-11-19 09:35:54,464 - INFO : (-2147352567, 'Exception occurred.', (0, None, None, None, 0, -2146777998), None)

Why?

gheber commented 9 years ago

I think I found the culprit. I tried to be "smart" and determine the location of a workbook with this function: =LEFT(CELL("filename"),FIND("[",CELL("filename"),1)-1) This seems to send Excel into a constant loop and the log begins to fill up with exception like this:

2014-11-20 07:16:33,099 - ERROR : Traceback (most recent call last): 2014-11-20 07:16:33,099 - ERROR : File "pyxll", line 2458, in run 2014-11-20 07:16:33,115 - ERROR : File "C:\Users\Gerd\git\PyHexad\pyhexad\renderer.py", line 47, in update_func 2014-11-20 07:16:33,115 - ERROR : xl = xl_app() 2014-11-20 07:16:33,115 - ERROR : File "C:\Users\Gerd\git\PyHexad\pyhexad\renderer.py", line 22, in xl_app 2014-11-20 07:16:33,115 - ERROR : xl_app = win32com.client.Dispatch(xl_window).Application 2014-11-20 07:16:33,115 - ERROR : File "C:\Python27\lib\site-packages\win32com\client\dynamic.py", line 522, in getattr 2014-11-20 07:16:33,115 - ERROR : raise AttributeError("%s.%s" % (self.username, attr)) 2014-11-20 07:16:33,115 - ERROR : AttributeError: .Application

Crisis averted 4 now...