IronCalc

IronCalc is a new, modern, work-in-progress spreadsheet engine and set of tools to work with spreadsheets in diverse settings.

This repository contains the main engine and the xlsx reader and writer.

Programmed in Rust, you will be able to use it from a variety of programming languages like Python, JavaScript (wasm), nodejs and possibly R, Julia or Go.

We will build different skins: in the terminal, as a desktop application or use it in you own web application.

Building

cargo build --release

Testing, linting and code coverage

Test are run automatically and test coverage can always be found in codecov

If you want to run the tests yourself:

make tests

Note that this runs unit tests, integration tests, linter tests and formatting tests.

If you want to run the code coverage yourself:

make coverage
cd target/coverage/html/
python -m http.server

API Documentation

Documentation is published at: https://docs.rs/ironcalc/latest/ironcalc/

It might be generated locally

$ make docs
$ cd target/doc
$ python -m http.server

And visit http://0.0.0.0:8000/ironcalc/

Simple example

Add the dependency to Cargo.toml:

[dependencies]
ironcalc = { git = "https://github.com/ironcalc/IronCalc", version = "0.1"}

And then use this code in main.rs:

use ironcalc::{
    base::{expressions::utils::number_to_column, model::Model},
    export::save_to_xlsx,
};

fn main() -> Result<(), Box<dyn std::error::Error>> {
    let mut model = Model::new_empty("hello-calc.xlsx", "en", "UTC")?;
    // Adds a square of numbers in the first sheet
    for row in 1..100 {
        for column in 1..100 {
            let value = row * column;
            model.set_user_input(0, row, column, format!("{}", value));
        }
    }
    // Adds a new sheet
    model.add_sheet("Calculation")?;
    // column 100 is CV
    let last_column = number_to_column(100).unwrap();
    let formula = format!("=SUM(Sheet1!A1:{}100)", last_column);
    model.set_user_input(1, 1, 1, formula);

    // evaluates
    model.evaluate();

    // saves to disk
    save_to_xlsx(&model, "hello-calc.xlsx")?;
    Ok(())
}

See more examples in the examples folder of the xlsx crate.

ROADMAP

See https://github.com/ironcalc

Early testing

An early preview of the technology running entirely in your browser:

https://playground.ironcalc.com

Collaborators needed!. Call to action

We don't have a vibrant community just yet. This is the very stages of the project. But if you are passionate about code with high standards and no compromises, if you are looking for a project with high impact, if you are interested in a better, more open infrastructure for spreadsheets, whether you are a developer (rust, python, TypeScript, electron/tauri/anything else native app, React, you name it), a designer (we need a logo desperately!), an Excel power user who wants features, a business looking to integrate a MIT/Apache licensed spreadsheet in your own SaaS application join us!

The best place to start will be to join or discord channel or send us an email at hello@ironcalc.com.

Many have said it better before me:

Folks wanted for hazardous journey. Low wages, bitter cold, long hours of complete darkness. Safe return doubtful. Honour and recognition in event of success.

License

Licensed under either of

• MIT license
• Apache license, version 2.0

at your option.