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.
- Checkout this repository
- Open & Build the
yajl_x64
Project - The generated yajl.lib is your
yajl_64.lib
- Open the
xlloop-addin_x64
Project - Create a lib folder, eg
xlloop-addin_x64\lib\x64
- Add the yajl_x64.lib (step 2.1) and the xlcall32.lib (excel sdk) into this directory
- Build the project
- Load the generated xlloop.xll into you 64bit excel