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
  1. Java 6 or higher is required. 

  2. Requires the ExcelDNA-IntelliSense add-in to also be installed (https://github.com/Excel-DNA/IntelliSense