Validation in excel using Java

Question

Suppose I have a value in an excel cell A5.Let it be 1.3.And then I have cells in the same column below the cell A5 like A6,A7,A8...with some value in it.

Is there any validation method in Java that when I change the value from 1.3 to 1.4 or some other value, all the values in the cells A6,A7,A8 .. gets changed to 1.4 that is becomes equal to A5 ?

Thanks for your answers beforehand.

Why would you need JAVA for that? It doesn't seem like there would be a problem to implement this with some simple formulas. — J. Maes
– J. Maes, Commented Jan 19, 2012 at 20:25
@J.Males : I need to generate the excel sheet through java.Well bear me..am new to this.. — Nabarun Bhowmick
– Nabarun Bhowmick, Commented Jan 19, 2012 at 20:31

J. Maes · Accepted Answer · 2012-01-19 20:45:36Z

1

My suggestion would be that you just insert the formulas in the cells through JAVA.

For example, in Excel you want to be a cell the total of two other cells:

C5: =A1+A2

If you for example use the Apache POI, you can use the setCellFormula method.

String formula = "=A1+A2";
cell.setCellFormula(formula);

Here is a little example of how to create the cell objects an how to use the apache POI

answered Jan 19, 2012 at 20:45

J. Maes

6,9125 gold badges30 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Validation in excel using Java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related