How to get numeric value from excel file cell, using POI

Question

I am pretty new to Selenium and learning through self study. Any help will be appreciable.

Currently I am using

String data = wb.getSheetAt(sheetnum).getRow(row).getCell(col).getStringCellValue();

It is working fine for String but not for numeric. I have a cell value of '500' and I want to fetch it. Please help.

@Debanjan There is a method defined as follows: public String getData(int sheetnum, int row, int col) { String data=wb.getSheetAt(sheetnum).getRow(row).getCell(col).getStringCellValue(); return data; } The numeric field I want to choose is driver.findElement(By.xpath("//input[@id='Weight']")).sendKeys(excel.getData(1, 1, 9)); — Paulami Sanyal
– Paulami Sanyal, Commented May 28, 2017 at 14:52
@PaulamiSanyal Can you consider to put your code block & the entire error stacktrace in the question area for further analysis please? Thanks — undetected Selenium
– undetected Selenium, Commented May 28, 2017 at 17:47

RNS · Accepted Answer · 2017-05-29 05:23:54Z

0

Try out following code :

public void readfile(String filepath, String filename, String sheetname)    throws IOException {


    File file = new File(filepath+"\\"+filename);
    FileInputStream fis = new FileInputStream(file);

    // for creating .xlsx workbook
    Workbook wb = new XSSFWorkbook(fis);

    // for reading the sheet by its name
    Sheet sh = wb.getSheet(sheetname);

    // find the total rows in sheet

    int rowcount = sh.getLastRowNum() - sh.getFirstRowNum();

    // create a loop to create

    for (int i = 0; i < rowcount + 1; i++) {
        Row row = sh.getRow(i);

        // create a loop to print cell values

        for (int j = 0; j < row.getLastCellNum(); j++) {
            Cell cell = row.getCell(j);
            switch (cell.getCellType()) {
            case Cell.CELL_TYPE_STRING:
                System.out.print(row.getCell(j).getStringCellValue() + " ");
                break;

            case Cell.CELL_TYPE_NUMERIC:
                System.out.print((int)row.getCell(j).getNumericCellValue() + " ");
                break;

            }

        }

        System.out.println();
    }

}

Hope it will help you.

answered May 29, 2017 at 5:23

RNS

6255 silver badges16 bronze badges

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

2 Comments

Paulami Sanyal Over a year ago

Thanks @Debanjan and @RNS! Somehow I managed to do it with below code.

Paulami Sanyal Over a year ago

Thanks @RNS. Somehow I managed to do it using below code and it worked. public String getNumericData(int sheetnum,int row, int col) { String data=String.valueOf((int)wb.getSheetAt(sheetnum).getRow(row).getCell(col).getNumericCellValue()); return data; }

Styx · Accepted Answer · 2017-09-24 18:42:31Z

0

Double data = wb.getSheetAt(sheetnum).getRow(row).getCell(col).getNumericCellValue();

edited Sep 24, 2017 at 18:42

Styx

10.1k8 gold badges48 silver badges56 bronze badges

answered Sep 24, 2017 at 18:06

Suroj Shrestha

11 bronze badge

Collectives™ on Stack Overflow

How to get numeric value from excel file cell, using POI

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related