Recalculate an Excel file

The following example shows you how to load an existing Excel workbook, recalculate all of its formulas and save the result. Use this when a file was produced by a tool that wrote formulas but no values, or when the cached values are out of date.

import com.independentsoft.calc.CalcResult;
import com.independentsoft.calc.CalcSession;
import com.independentsoft.office.spreadsheet.Workbook;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Workbook book = new Workbook("c:\\test\\input.xlsx");

            CalcSession session = new CalcSession();
            CalcResult result = session.calculate(book);

            System.out.println("Formula cells: " + result.getFormulaCellCount());
            System.out.println("Calculated: " + result.getCalculatedCellCount());
            System.out.println("Failed: " + result.getFailedCellCount());

            book.save("c:\\test\\output.xlsx", true);
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

JCalc > Tutorial > Recalculate an Excel file

Need help? Ask our developers: