How to read floating values from excel in java and selenium

Question

I want to read values like 11610.1073 from excel using java and selenium. I tried below code but it throws me null pointer exception when I am trying to parse that value and store it in array variable. I am able to read int values but unable to do the same with the float values. Below is my code:

StagePTDFTE.add(Float.parseFloat(row.getCell(2).getStringCellValue().toString()));
StagePTDFTEArray = new float[StagePTDFTE.size()];
    for (int i = 0; i < StagePTDFTEArray.length; i++) {
        StagePTDFTEArray[i] = Float.parseFloat(df.format(StagePTDFTE.get(i)));
            }

Please let me know where I am going wrong and what should be the modifications required here. Thanks in advance :)

Row.getCell may return null. So, as for each NullPointerException, you have to check if it returns null and do only using it if not. See poi.apache.org/spreadsheet/…. — Axel Richter
– Axel Richter, Commented Jan 5, 2018 at 6:14

Siddhesh · Accepted Answer · 2018-01-05 06:12:29Z

1

Try using Data DataFormatter

All you need to do this:

// Only need one of these
DataFormatter fmt = new DataFormatter();

// Once per cell
String valueAsSeenInExcel = fmt.formatCellValue(cell);

answered Jan 5, 2018 at 6:12

Siddhesh

1,1731 gold badge11 silver badges25 bronze badges

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

3 Comments

user7955767 Over a year ago

Yeah it works but the problem is if i want to read multiple values of that column then this doesnt work. It only reads last value of that particular column. So how can it be achieved ?

user7955767 Over a year ago

i sorted it out with the below code. Thanks so much @Siddhesh .

user7955767 Over a year ago

DataFormatter fmt = new DataFormatter(); overdueList.add(fmt.formatCellValue(row.getCell(4))); //Where //overdueList is String arraylist for (int i = 0; i < overdueList.size(); i++) { System.out.println("Values are " + overdueList.get(i).replace("%", "")); }

Collectives™ on Stack Overflow

How to read floating values from excel in java and selenium

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related