How to extract double int value from excel sheet using selenium

Question

Following is the code I used for extracting any value from excel sheet. Cell value can be string ,date or long int. Using below code I am able to extract string and date correctly but long int values are coming in as 4.6861230317E10 instead of 46861230317. How to overcome this issue??

 Cell = ExcelWSheet.getRow(RowNum).getCell(ColNum); 
                if(Cell.getCellTypeEnum() == CellType.STRING)
                {

                    System.out.println("check for celltype string");
                    CellData = Cell.getStringCellValue();
                    System.out.println("String CellData:"+CellData);
                }   
                else  
                if(Cell.getCellTypeEnum() == CellType.NUMERIC)
                {
                    System.out.println("checking for celltype numeric");
                    CellData = fmt.formatCellValue(Cell);
                    if(CellData.contains("/"))
                    {
                        System.out.println("its a date !"+CellData);
                    }
                    else if(!CellData.contains("/"))
                    {

                        double  CellData2 = (double)Cell.getNumericCellValue(); 
                        System.out.println("actual double value "+CellData2);
                        CellData=String.valueOf(CellData2);
                        System.out.println("its a double int numeric value "+CellData);

                    }

                }   
                System.out.println("returning cell data "+CellData);
                return CellData;

RNS · Accepted Answer · 2017-04-19 09:48:06Z

1

Try following line implementation in your code

cell.setCellType(Cell.CELL_TYPE_STRING)

It worked for me.

answered Apr 19, 2017 at 9:48

RNS

6255 silver badges16 bronze badges

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

Comments

aswathy · Accepted Answer · 2017-04-19 10:01:59Z

0

Instead of

double  CellData2 = (double)Cell.getNumericCellValue();

use

long CellData2 = new Double(Cell.getNumericCellValue()).longValue();

It works just fine too !!!

answered Apr 19, 2017 at 10:01

aswathy

8314 gold badges15 silver badges27 bronze badges

Collectives™ on Stack Overflow

How to extract double int value from excel sheet using selenium

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related