JXLL provides an interface for interacting with Excel Addins (XLLs). It gives java developers access to function information and can execute any exposed functions.

JXLL is licensed under the Common Public License (CPL).

The latest download is available from the Project Page.

The following example shows how to load an XLL and invoke a function:

import org.boris.jxll.Addin;
import org.boris.jxll.XLL;
import org.boris.jxll.XLOper;

public class JXLLExample
{
    public static void main(String[] args) throws Exception {
        System.out.println("Loading TestXLL.dll...");
        
        // Load the XLL and check the  result
        Addin a = XLL.load("TestXLL.dll");
        if (a == null) {
            System.out.println("Failed to load addin");
            return;
        }
        
        // Create some random arguments
        double a1 = Math.round(Math.random() * 60000) / 100.;
        double a2 = Math.round(Math.random() * 4000) / 100.;
        System.out.println("Invoking TestSum(" + a1 + "," + a2 + ")");
        
        // Invoke the TestSum functon
        XLOper res = a.invoke("TestSum", new Double(a1), new Double(a2));
        
        // Output the result
        System.out.println(res.num);
    }
}

V0.0.2

• Improved handling of function registration.

V0.0.1

• Initial version.