Search code examples
javaexcel-dna

Exceldna equivalent for Java

ExcelDNA is a fantastic resource for C# developers - is there anything similar for Java?

Solution

  • I think what comes nearest is XLL4J – Excel Addin Framework for Java, still Alpha though.

    XLL4J is a framework for developing Microsoft Excel addins (XLLs) in Java. It provides a mechanism for implementing Excel functions in Java and has the following features:

    • Easy Java VM management via INI file (refer to table below for details).
    • Two APIs; one low-level and one reflection based for easy implementation.
    • Built-in CSV addin for accessing CSV from filesystem or network.

    and of course the linked project XLLoop – Excel User-Defined Functions in Java, Javascript, Ruby, Python, Erlang.

    XLLoop is an open source framework for implementing Excel user-defined functions (UDFs) on a centralised server (a function server).