Home » Forums » Open Source Learning Center » Question and Answer

Cant retrieve auto fill value from java

Submitted by harish on 21 November, 2012 - 10:41

Hi All,

I am trying to auto fill the cell value of a column based on previous two columns for that i have a formula as..

= INDEX(Sheet2!$D$2:$D$102, MATCH(1, (Sheet2!$A$2:$A$102 = $A2) * (Sheet2!$B$2:$B$102 = $B2) .....

The value is updating but when i am trying to retrieve this value from java using apache poi i m getting formula of that particular cell instead of its valu how to get the auto fill value...plz help its urgent..

‹ Remove PERSONAL.XLSK how i connect sheet of another outside sheet ›
»
Nick's picture

what's the java code that's

Submitted by Nick on 21 November, 2012 - 12:11.

what's the java code that's picking up the value ?
.. and if you copy and paste special values, does the Java code work ?

»

I am using

Submitted by harish on 21 November, 2012 - 13:12.

I am using row.getCell(cellnum) to get values of a cell here its returning formula of that cell instead of its value

»
Nick's picture

Cell cell =

Submitted by Nick on 21 November, 2012 - 14:24.

Cell cell = row.getCell(cellnum());
System.out.println(cell.getNumericCellValue());

»

thank you so much..that

Submitted by harish on 23 November, 2012 - 05:04.

thank you so much..that solved my issue..

»