AFC - Abacus Formula Compiler for Java

Your users want to customize formulas. They know Excel or OpenOffice.

// Compile price finding factory and strategy implementation from spreadsheet:
EngineBuilder builder = SpreadsheetCompiler.newEngineBuilder();
builder.loadSpreadsheet( new File( PATH, "CustomPriceFormula.xls" ) );
builder.setFactoryClass( PriceFinderFactory.class );
builder.bindAllByName();
Engine engine = builder.compile();
PriceFinderFactory factory = (PriceFinderFactory) engine.getComputationFactory();

// Use it to compute a line item price:
LineItem item = getCurrentLineItem();
PriceFinder priceFinder = factory.newInstance( item );
BigDecimal price = priceFinder.getPrice();

Compile parametrized spreadsheets directly to bytecode.

  • No need to have Excel, OpenOffice, or a JDK installed.
  • Native speed, thread safe execution.
  • Bind directly to your computation strategy interfaces.
  • Using double, or BigDecimal for financial applications.
  • Available under the GPL and commercially (details).

Abacus Formula Compiler for Java

Download it now!

Quick start your first compiled spreadsheet. Has you up and running in just a few minutes.

Learn more about the goals, the design, the API, and the supported functions.

News

Release 1.2

adds support for Microsoft Office Open XML (MS Excel 2007) spreadsheets.
November 4, 2008

Release 1.1

adds better support for OpenOffice Calc spreadsheets.
July 4, 2008