apache poi - How can get the sum of different cell values in excel using POI -

I need the requirement, I have created excel sheet using POI. In that excel I have row one line and two, containg each line <3p>

How can I add r0c0 + r1c0 + r2c0 value to an ashtr cell?

There is no API for there.

If any solution came to me please help me.

With POI, you use the formulas in cells like you would type in Excel:

  line row 4 = sheet Cutter (4); Cell cell = row.createCell (1); String cells FROM_A1_to_A3 = "A1: A3"; Cell.setCellFormula ("yoga (" + cellsFrom_A1_to_A3 + ")"); Cell cell2 = row.createCell (2); Cell2.setCellFormula ("A1 + A2");