AsposeFormulaCalculationEngine.java

package asposefeatures.datahandlingfeatures.formulacalculationengine.java;

import com.aspose.cells.Cell;
import com.aspose.cells.Cells;
import com.aspose.cells.Workbook;
import com.aspose.cells.Worksheet;

public class AsposeFormulaCalculationEngine
{
    public static void main(String[] args) throws Exception
    {
	String dataPath = "src/asposefeatures/datahandlingfeatures/formulacalculationengine/data/";

	// Instantiating a Workbook object
	Workbook book = new Workbook();

	// Obtaining the reference of the newly added worksheet
	int sheetIndex = book.getWorksheets().add();
	Worksheet worksheet = book.getWorksheets().get(sheetIndex);
	Cells cells = worksheet.getCells();
	Cell cell = null;

	// Adding a value to "A1" cell
	cell = cells.get("A1");
	cell.setValue(1);

	// Adding a value to "A2" cell
	cell = cells.get("A2");
	cell.setValue(2);

	// Adding a value to "A3" cell
	cell = cells.get("A3");
	cell.setValue(3);

	// Adding a SUM formula to "A4" cell
	cell = cells.get("A4");
	cell.setFormula("=SUM(A1:A3)");

	// Calculating the results of formulas
	book.calculateFormula();

	// Saving the Excel file
	book.save(dataPath + "AsposeFormulaEngine.xls");
	System.out.println("Done.");
    }
}