Read a calculated cell value

The following example shows you how to read the value of a formula cell after calculation. CalcSession writes the result into the cached value of the cell, so getValue() returns the calculated result while getFormula() still holds the formula.

import com.independentsoft.calc.CalcSession;
import com.independentsoft.office.spreadsheet.Cell;
import com.independentsoft.office.spreadsheet.Row;
import com.independentsoft.office.spreadsheet.Sheet;
import com.independentsoft.office.spreadsheet.Workbook;
import com.independentsoft.office.spreadsheet.Worksheet;

public class Example {

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

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

            for (Sheet sheet : book.getSheets())
            {
                if (!(sheet instanceof Worksheet))
                {
                    continue;
                }

                Worksheet worksheet = (Worksheet) sheet;

                for (Row row : worksheet.getRows())
                {
                    for (Cell cell : row.getCells())
                    {
                        if (cell.getFormula() != null)
                        {
                            System.out.println(worksheet.getName() + "!" + cell.getReference() + " =" + cell.getFormula().getBody() + " -> " + cell.getValue());
                        }
                    }
                }
            }
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

JCalc > Tutorial > Read a calculated cell value

Need help? Ask our developers: