Scrambled text when opening PyXLL? This is usually caused by trying to load the 32 bit version of PyXLL into a 64 bit version of Excel, or vice versa. Check your Excel version and download the correct version of PyXLL.
Follow the guide to Installing the PyXLL Excel Add-In. If you get any errors then try setting the log verbosity to debug in the LOG section of your pyxll.cfg file:
[LOG]
verbosity = debug
Now restart Excel and try again, and PyXLL will output more information about what it’s doing to the log file set in your config. If you don’t understand what’s going wrong from there please contact us via the forum or email and we’ll be happy to help.
If there is no log output at all, try setting the environment variable ‘PYXLL_DEBUG_LOG’ to a filename on your local PC where you have write access, for example C:/Temp/pyxll.log.
See this link if you’re not sure how to change an environment variable on Windows: http://www.computerhope.com/issues/ch000549.htm.
If Excel complains that the pyxll.xll file is the wrong file format or is an invalid addin then the most likely cause is that you’re trying to load the 64 bit addin into a 32 bit Excel, or vice versa. To solve this, download the correct version and try again. Please note that you will have to also have the same version of Python as Excel, as PyXLL runs in-process and 32 bit processes can’t load 64 bit addins.
If you are still having problems please contact us and we will be able to help! The first thing you are likely to be asked for is a copy of your log file with the verbosity set to ‘debug’.