Introduction
Features
- Write Excel worksheet functions, macros and menu items in Java, Scala, Kotlin and Clojure.
- Reload and test without restarting Excel
- All versions of Excel from 2003 onwards supported, including Office 365 and Excel 2016
- Works with both 32 bit and 64 bit versions of Excel
- Uses the JVM1 of your choice via configuration
- Excel functions can be documented, including parameter documentation
- Pass Java objects between functions via a managed object cache
- Automatically resizing array functions
- Real time data (RTD) function support
- Customize the Excel ribbon and add context menus
- Add custom argument converters to avoid repeated code
- Thread-safe functions run across multiple threads from Excel 2010 onwards
- Automatic IntelliSense for exposed functions2
-
Java 6 or higher is required. ↩
-
Requires the ExcelDNA-IntelliSense add-in to also be installed (https://github.com/Excel-DNA/IntelliSense) ↩