Overview

In this post, we will write a simple program to read an excel row using Apache POI.

First of all, let us create a simple excel file with data to read. I’m gonna use movie names in my excel with 2 columns. I will read one movie name at a time as shown below excel file. The filename of the excel is TDocs.xlsx.

 

Sample Program to read an excel row

The simple method to get one single row is shown below:

public ArrayList<String> getMyRow(int rowIndex, int endColIndex,int sheetIndex) throws IOException{
        ArrayList<String> rsData = new ArrayList<String>();
        try {
            file = new File("TDocs.xlsx");
            fis = new FileInputStream(file);
            workbook = new XSSFWorkbook(fis);
            sheet = workbook.getSheetAt(sheetIndex);
            for(int colStartPosition=0; colStartPosition<=endColIndex; colStartPosition++){
                Cell cell = sheet.getRow(rowIndex).getCell(colStartPosition);

            switch(cell.getCellType()) {
            case Cell.CELL_TYPE_STRING: 
            rsData.add(cell.getStringCellValue());
            break;
            }
            }
       
        }catch (Exception e) {
            e.printStackTrace();
        }
        finally{
            fis.close();
            }
        return rsData;
    }

 

 

Now, I will consume this method to read the data by passing the row index, columns I want to read.

public static void main(String... args) throws IOException
    {
        ArrayList<String> consume = new ArrayList<String>();
        ReadXL readexcel = new ReadXL();
        consume = readexcel.getMyRow(1, 1, 0);
        System.out.println("**********OutPut************");
        for(String s : consume)
        {
            System.out.print(s);
        }
        
    }

 

Run output of the program is displayed below :

**********OutPut************
TheIntern

 

 

This post is to demonstrate how we can read data from an existing excel file which can be used in Selenium Automation for reading test data from an excel file.