Author Topic: pyxll 2.2.0-beta3 didn't run...  (Read 1092 times)

depth

  • Newbie
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
pyxll 2.2.0-beta3 didn't run...
« on: August 01, 2014, 05:19:29 PM »
Dear Tony,

I installed Canopy 1.4.1.1975 32bit Academic product, and using office 2013 32bit.
I didn't change the pyxll.cfg, it didn't work...
I saw this log message and I couldn't find the solution.

2014-08-02 01:08:39,990 - INFO :
------------------------------------------------------------------------------
  PyXLL

  Version          2.2.0.beta3
  Buildtime        2014-05-26 18:31
  Python version   2.7.6.final.0
  Excel version    15.0

  www.pyxll.com
------------------------------------------------------------------------------

2014-08-02 01:08:39,992 - ERROR : # C:\Users\depths\AppData\Local\Enthought\Canopy32\User\lib\site-packages\pyxll\examples\misc.pyc matches C:\Users\depths\AppData\Local\Enthought\Canopy32\User\lib\site-packages\pyxll\examples\misc.py
2014-08-02 01:08:39,992 - ERROR : import misc # precompiled from C:\Users\depths\AppData\Local\Enthought\Canopy32\User\lib\site-packages\pyxll\examples\misc.pyc
2014-08-02 01:08:39,993 - ERROR : # C:\Users\depths\AppData\Local\Enthought\Canopy32\User\lib\site-packages\pyxll\examples\worksheetfuncs.pyc matches C:\Users\depths\AppData\Local\Enthought\Canopy32\User\lib\site-packages\pyxll\examples\worksheetfuncs.py
2014-08-02 01:08:39,993 - ERROR : import worksheetfuncs # precompiled from C:\Users\depths\AppData\Local\Enthought\Canopy32\User\lib\site-packages\pyxll\examples\worksheetfuncs.pyc
2014-08-02 01:08:39,994 - ERROR : # C:\Users\depths\AppData\Local\Enthought\Canopy32\User\lib\site-packages\pyxll\examples\customtypes.pyc matches C:\Users\depths\AppData\Local\Enthought\Canopy32\User\lib\site-packages\pyxll\examples\customtypes.py
2014-08-02 01:08:39,994 - ERROR : import customtypes # precompiled from C:\Users\depths\AppData\Local\Enthought\Canopy32\User\lib\site-packages\pyxll\examples\customtypes.pyc
2014-08-02 01:08:39,996 - ERROR : # C:\Users\depths\AppData\Local\Enthought\Canopy32\User\lib\site-packages\pyxll\examples\asyncfunc.pyc matches C:\Users\depths\AppData\Local\Enthought\Canopy32\User\lib\site-packages\pyxll\examples\asyncfunc.py
2014-08-02 01:08:39,996 - ERROR : import asyncfunc # precompiled from C:\Users\depths\AppData\Local\Enthought\Canopy32\User\lib\site-packages\pyxll\examples\asyncfunc.pyc
2014-08-02 01:08:39,997 - ERROR : # C:\Users\depths\AppData\Local\Enthought\Canopy32\App\appdata\canopy-1.4.1.1975.win-x86\lib\urllib2.pyc matches C:\Users\depths\AppData\Local\Enthought\Canopy32\App\appdata\canopy-1.4.1.1975.win-x86\lib\urllib2.py
2014-08-02 01:08:39,997 - ERROR : import urllib2 # precompiled from C:\Users\depths\AppData\Local\Enthought\Canopy32\App\appdata\canopy-1.4.1.1975.win-x86\lib\urllib2.pyc
2014-08-02 01:08:40,000 - ERROR : # C:\Users\depths\AppData\Local\Enthought\Canopy32\App\appdata\canopy-1.4.1.1975.win-x86\lib\base64.pyc matches C:\Users\depths\AppData\Local\Enthought\Canopy32\App\appdata\canopy-1.4.1.1975.win-x86\lib\base64.py
2014-08-02 01:08:40,000 - ERROR : import base64 # precompiled from C:\Users\depths\AppData\Local\Enthought\Canopy32\App\appdata\canopy-1.4.1.1975.win-x86\lib\base64.pyc
2014-08-02 01:08:40,000 - ERROR : # C:\Users\depths\AppData\Local\Enthought\Canopy32\App\appdata\canopy-1.4.1.1975.win-x86\lib\struct.pyc matches C:\Users\depths\AppData\Local\Enthought\Canopy32\App\appdata\canopy-1.4.1.1975.win-x86\lib\struct.py
2014-08-02 01:08:40,000 - ERROR : import struct # precompiled from C:\Users\depths\AppData\Local\Enthought\Canopy32\App\appdata\canopy-1.4.1.1975.win-x86\lib\struct.pyc
2014-08-02 01:08:40,000 - ERROR : import _struct # builtin
2014-08-02 01:08:40,002 - ERROR : import binascii # builtin
...
2014-08-02 01:08:40,111 - ERROR : import tools # precompiled from C:\Users\depths\AppData\Local\Enthought\Canopy32\User\lib\site-packages\pyxll\examples\tools\__init__.pyc
2014-08-02 01:08:40,111 - ERROR : # C:\Users\depths\AppData\Local\Enthought\Canopy32\User\lib\site-packages\pyxll\examples\tools\eclipse_debug.pyc matches C:\Users\depths\AppData\Local\Enthought\Canopy32\User\lib\site-packages\pyxll\examples\tools\eclipse_debug.py
2014-08-02 01:08:40,111 - ERROR : import tools.eclipse_debug # precompiled from C:\Users\depths\AppData\Local\Enthought\Canopy32\User\lib\site-packages\pyxll\examples\tools\eclipse_debug.pyc
2014-08-02 01:08:40,114 - WARNING : pydevd failed to import - eclipse debugging won't work
2014-08-02 01:08:40,114 - WARNING : Check the eclipse path in C:\Users\depths\AppData\Local\Enthought\Canopy32\User\lib\site-packages\pyxll\examples\tools\eclipse_debug.pyc
2014-08-02 01:08:40,115 - ERROR : # C:\Users\depths\AppData\Local\Enthought\Canopy32\User\lib\site-packages\pyxll\examples\tools\reload.pyc matches C:\Users\depths\AppData\Local\Enthought\Canopy32\User\lib\site-packages\pyxll\examples\tools\reload.py
2014-08-02 01:08:40,115 - ERROR : import tools.reload # precompiled from C:\Users\depths\AppData\Local\Enthought\Canopy32\User\lib\site-packages\pyxll\examples\tools\reload.pyc
2014-08-02 01:08:40,115 - INFO : callbacks.license_notifier: This copy of PyXLL is for evaluation or non-commercial use only
2014-08-02 01:08:41,651 - ERROR : Function 'pyxll_version' has no entry in the dll export table.
2014-08-02 01:08:41,651 - ERROR : Function 'python_version' has no entry in the dll export table.
2014-08-02 01:08:41,651 - ERROR : Function 'win32api_is_installed' has no entry in the dll export table.
2014-08-02 01:08:41,651 - ERROR : Function 'win32com_is_installed' has no entry in the dll export table.
2014-08-02 01:08:41,651 - ERROR : Function 'numpy_is_installed' has no entry in the dll export table.
2014-08-02 01:08:41,651 - ERROR : Function 'pyxll_logfile' has no entry in the dll export table.
2014-08-02 01:08:41,651 - ERROR : Function 'get_formula' has no entry in the dll export table.
2014-08-02 01:08:41,651 - ERROR : Function 'get_array_formula' has no entry in the dll export table.
...

How could I solve this problem? Thank you.

Tony

  • Administrator
  • Hero Member
  • *****
  • Posts: 574
  • Karma: +13/-1
    • View Profile
Re: pyxll 2.2.0-beta3 didn't run...
« Reply #1 on: August 03, 2014, 06:26:01 PM »
Hi,

2.2.0 can be downloaded from pyxll.com and you should try using that instead of the earlier 2.2.0.beta3. I will check with the team that produce the pyxll package for Enthought as it shouldn't be using this beta version.

What you can try doing is to close Excel, delete the old pyxll.xll file installed by canopy (it will be in C:\Users\depths\AppData\Local\Enthought\Canopy32\User\lib\site-packages\pyxll), and replace it with the pyxll.xll from the zip file downloaded from pyxll.com.

Once you've done that, if you get the same errors try setting the environment variable PYXLL_DEBUG_LOG=c:\Temp\pyxll-debug.log and restart Excel. PyXLL will then log more information during start up that may help diagnose what's gone wrong.

Best regards,
Tony

depth

  • Newbie
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Re: pyxll 2.2.0-beta3 didn't run...
« Reply #2 on: August 04, 2014, 02:34:21 AM »
Dear Tony,

I replaced the pyxll.xll downloaded from the "pyxll.com" and when I import it on the excel, it looks successfully loaded.
but the in the log file the same ERROR messages are coming..

2014-08-04 10:26:39,542 - ERROR : Function 'pyxll_version' has no entry in the dll export table.
2014-08-04 10:26:39,542 - ERROR : Function 'python_version' has no entry in the dll export table.
...

I thought messages look like the example folder problem, I added the my_xl_addin_module in the pyxll.cfg, but it also make the error message.

2014-08-04 10:26:39,552 - ERROR : Function 'hello' has no entry in the dll export table.

I attached the pyxll-debug.log...
Thanks.

Tony

  • Administrator
  • Hero Member
  • *****
  • Posts: 574
  • Karma: +13/-1
    • View Profile
Re: pyxll 2.2.0-beta3 didn't run...
« Reply #3 on: August 04, 2014, 10:07:27 AM »
Hi,

this is a bit odd. I've not come across this particular problem before... it looks as if everything is loading correctly, but for some reason when the dll export table is updated with the new functions the check that looks for them before registering them with Excel doesn't find them.

I've not been able to reproduce this problem here, but I can add more logging around where that error is occurring to try and narrow it down.

Before I do that though, please could you tell me which version of Windows you're using, and also please can you check you have applied all updates and service packs?

The latest service pack for Excel 2013 is SP1 which you can get from here:
http://support.microsoft.com/kb/2817430

And you can get the latest windows service packs here:
http://windows.microsoft.com/en-GB/windows/service-packs-download

Best regards,
Tony

depth

  • Newbie
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Re: pyxll 2.2.0-beta3 didn't run...
« Reply #4 on: August 04, 2014, 05:43:29 PM »
Dear Tony,

Yes, I already updated both of Excel 2013 SP1(KB2850036) and windows7 service pack(KB976932).

Here is the one question,
I set the both of Excel and Windows language to KOREAN. Is it possible to make the problem on pyxll?

Thank you.

Tony

  • Administrator
  • Hero Member
  • *****
  • Posts: 574
  • Karma: +13/-1
    • View Profile
Re: pyxll 2.2.0-beta3 didn't run...
« Reply #5 on: August 04, 2014, 05:57:23 PM »
Ah, that's certainly something that's never been tested and so yes that could well the the source of the problem.

Are you able to change the language to english and see if that fixes it? If it does I can look at why it doesn't work for different character sets.

Best regards,
Tony

depth

  • Newbie
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Re: pyxll 2.2.0-beta3 didn't run...
« Reply #6 on: August 04, 2014, 07:12:34 PM »
Dear Tony,

I just changed the language to ENG from KOR. but still had same errors.
I attach the LOG file.

As you saw the log file before, I installed Office and Canopy in D drive not to C drive. Isn't it cause the problem?

Thanks.

Tony

  • Administrator
  • Hero Member
  • *****
  • Posts: 574
  • Karma: +13/-1
    • View Profile
Re: pyxll 2.2.0-beta3 didn't run...
« Reply #7 on: August 04, 2014, 07:58:13 PM »
Hi,

I suspect that if it is a language thing it will be the windows install that's the problem. It's when it adds the functions the dll it then checks to make sure the windows API (and hence Excel) can see them, but in your case it can't.

I can add a load more logging and send you a patched dll to try later this week, if you would be willing to help track down the problem? If you happen to have access to another PC (or VM) with the English version of windows installed you could check that works, and then that would be a good indication it is the windows language that's the problem.

I'll also try getting a non-uk VM built so I can test this too, but that may take a little longer.

Best regards,
Tony

depth

  • Newbie
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Re: pyxll 2.2.0-beta3 didn't run...
« Reply #8 on: August 05, 2014, 05:31:13 PM »
Dear Tony,

I tested another PC which installed Korean version, it worked well...
It means the language is not the problem at all.

I didn't check carefully, the difference of two PC is just OS operation bits. (32/64)
If I figure out the major difference then I will let you know.

Thanks