Data not getting printed in excel sheet after using formula

Question

I am trying to use XSSFRow to use data from one sheet to other,here is the code

XSSFRow r = nfrntSheet.getRow(i);
Cell c = r.createCell(7);
c.setCellFormula("'Original'!F"+(i+1)+"+'Original'!G"+(i+1)+"*-1");

After computing the formula the data in the written sheet will be displaced like "#value" instead of the number. what should i do to so that original data is displayed instead of the "#value"

score 1 · Accepted Answer · answered Aug 17 '16 at 15:05

1

you need to set the cell type

c.setCellType(XSSFCell.CELL_TYPE_FORMULA);

so as per your code

XSSFRow r = nfrntSheet.getRow(i);
Cell c = r.createCell(7);
 c.setCellType(XSSFCell.CELL_TYPE_FORMULA);

c.setCellFormula("'Original'!F"+(i+1)+"+'Original'!G"+(i+1)+"*-1");

answered Aug 17 '16 at 15:05

SpringLearner

13,738
20
78
116

Thx SpringLearner for the answer, But there is no change in the excel sheet – Anand Biradar Aug 17 '16 at 15:13
@AnandBiradar is the formula correct? did you execute the formula in the excel? – SpringLearner Aug 17 '16 at 15:16
I am getting this kind for error only for numeric data and not for String values – Anand Biradar Aug 17 '16 at 15:17
@AnandBiradar I think you need to set the data format also check it here http://stackoverflow.com/a/15248651/2664200 – SpringLearner Aug 17 '16 at 15:19
Thanks SpringLearner – Anand Biradar Aug 17 '16 at 18:10

Data not getting printed in excel sheet after using formula

1 Answers1