We have created an own solution to connect any user defined functions into Excel. Check out: Opuxl

Tested on Windows 7 64bit, Microsoft Visual Studio 2015 Community Edition, Microsoft Excel 2016 64bit

Excel User-Defined Functions in Java, Javascript, Ruby, Python, Erlang

More information and downloads can be found at: xlloop.sf.net

You need the following two libraries compiled for x64:

• xlcall32.lib : Download and install the Excel SDK. You'll find the lib in <installdir>/Excel2013XLLSDK/Excel2013XLLSDK/lib/x64

• yajl.lib : Compiled via this project

• JDK >7 should be installed with JAVA_HOME environment variable set appropriately.

• Microsoft Foundation Classes for C++ are also required for building the XLLoop.xll.

1. Checkout this repository
2. Open & Build the yajl_x64 Project
3. The generated yajl.lib is your yajl_64.lib
4. Open the xlloop-addin_x64 Project
5. Create a lib folder, eg xlloop-addin_x64\lib\x64
6. Add the yajl_x64.lib (step 2.1) and the xlcall32.lib (excel sdk) into this directory
7. Build the project
8. Load the generated xlloop.xll into you 64bit excel