Excel to Java

Convert Excel to Java code

Turn Excel formulas into a Java library and a Javalin REST API, built with Gradle and tested with JUnit 5, running on a compiled Rust engine.

How it works

  1. 1

    Tag inputs and outputs

    Mark which cells in your workbook are inputs and which are results. Your formulas stay exactly as they are.

  2. 2

    Generate Java code

    Codcel reads every formula and dependency and generates a Java project that you own.

  3. 3

    Test against Excel

    Generated tests compare the code's results with your workbook's values, so you can show they match.

What Codcel generates for Java

Calculation library

Every calculation in your workbook becomes a Java function with typed inputs and outputs.

REST API server

One POST endpoint per calculation, with JSON in and out, CORS, and an OpenAPI 3 description.

Web client

A typed Java client for the generated REST server that handles the HTTP calls and JSON for you.

Powered by a compiled Rust engine

The Java code calls Codcel's open-source calculation engine, compiled from Rust, through JNI. You get Java ergonomics with native speed.

Calling the generated code

Each calculation in your workbook becomes a function. In this example the workbook has a calculation named monthly_payment.

// Default formatting
var result = Calculation.monthlyPayment(input);

// With a per-call language override
var result = Calculation.monthlyPaymentWithLanguage(input, "de");

Build and test

Build system
Gradle (Jackson, JUnit 5)
Prerequisites
JDK 11+
Build
./gradlew build
Test
./gradlew test
Server framework
Javalin 6 (default port 7000)
Read the documentation

Why teams use Codcel

460+ Excel functions

Lookups, dynamic arrays, financial, statistical, text and date functions, with the known differences from Excel documented.

Source code you own

No proprietary runtime and no lock-in. The code lives in your repository and is reviewed like any other code.

Built for large models

Tables with millions of rows, including a one-billion-row benchmark, run through the same engine.

Proven against Excel

Generated tests check the code's results against the values in your spreadsheet.

Frequently asked questions

Can Codcel convert any Excel spreadsheet to Java?
Codcel converts the formulas, named ranges and tables in .xlsx, .xlsb and .xls workbooks, and supports more than 460 Excel functions. The documentation lists every supported function and the few known differences from Excel.
Do I need to rewrite my formulas?
No. You mark which cells are inputs and outputs, and Codcel reads your formulas as they are.
Is the generated Java code readable?
Yes. It is ordinary source code with typed inputs and outputs and generated tests. Your developers can review it, version it and change it.
Does the generated code need Excel or a Codcel service?
No. The generated project runs without Excel and without calling any Codcel service. It includes the open-source Codcel calculation engine, which is built along with your code.
How much does it cost?
Codcel is free for personal use. Commercial use runs on credits, and every plan includes the full source code and all generation options.

Turn your spreadsheet into Java code

Download Codcel Desktop for free, or bring your hardest model to a 30-minute demo.