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.0

is the first public GPL release and adds a host of changes.
February 21, 2008