how to get integer value from Ms Excel to java

Question

I imported Apache.POI package and want to get integer value from Excel cell to Java console. I know how get the string value from excel cell to Java console

System.out.println(sh1.getRow(0).getCell(2).getRichStringCellValue().toString());

but i don't know how to get integer value. Please help me.

The code is below.

import java.io.FileOutputStream;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.Sheet;

import org.apache.poi.ss.util.WorkbookUtil; 

import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Cell;

public class Excel {

    public static void main(String[] arg){
        Workbook workbook = new HSSFWorkbook();

        Sheet sh1 = workbook.createSheet("sheet1");

        Cell cell1 = sh1.createRow(0).createCell(0);
        Cell cell2 = sh1.createRow(0).createCell(1);
        Cell cell3 = sh1.createRow(0).createCell(2);


        cell1.setCellValue(100);
        cell2.setCellValue(200);
        cell3.setCellFormula("A1+B1");


        //Here!! I want to get integer value of cell3
        System.out.println(sh1.getRow(0).getCell(2).....);

        ..........
    }

}

thanks

Did you take a look at Busy Developers' Guide?

user180100
– user180100

2014-11-27 07:20:48 +00:00
Commented Nov 27, 2014 at 7:20 — user180100
– user180100, Commented Nov 27, 2014 at 7:20
i have to look that up!

imhyung
– imhyung

2014-11-27 07:24:48 +00:00
Commented Nov 27, 2014 at 7:24 — imhyung
– imhyung, Commented Nov 27, 2014 at 7:24

Jens · Accepted Answer · 2014-11-27 07:22:16Z

1

Use the function getNumericCellValue(). See the documentation of HSSFCell for more information.

answered Nov 27, 2014 at 7:22

Jens

69.6k15 gold badges107 silver badges133 bronze badges

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

5 Comments

imhyung Over a year ago

i tried .. but there is error msg with "Exception in thread "main" java.lang.NullPointerException at Excel.Excel.main(Excel.java:36)"

Jens Over a year ago

@imhyung Try to find out wich value is null. sh1, sh1.getRow(0) ... it has nothing to do with the numeric value.

imhyung Over a year ago

and 'getNumbericCellValue()' returns double, so i also made return value to double. but still shows the same error msg.

Jens Over a year ago

Looks like sh1.getRow(0) or sh1.getRow(0).getCell(2) is null. So you get the NPE

imhyung Over a year ago

cell3.getNumbericCellValue()is working instead sh1.rownumber.cellnumber.getNumbericCellValue() Thanks man!!

Collectives™ on Stack Overflow

how to get integer value from Ms Excel to java

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related