Reading data from excel file by using maven poi dependencies.

add this dependencies in maven pom.xml file or visit this site to download latest dependencies

https://mvnrepository.com/artifact/org.apache.poi/poi 

<dependency>

        <groupId>org.apache.poi</groupId>

        <artifactId>poi</artifactId>

        <version>3.15</version>

    </dependency>

    <dependency>

        <groupId>org.apache.poi</groupId>

        <artifactId>poi-ooxml</artifactId>

        <version>3.15</version>

    </dependency>

--------------------------------------------------------------------------------------------------------------------------

package com.qa.tests;

import java.io.FileInputStream;

import java.io.IOException;

import org.apache.poi.EncryptedDocumentException;

import org.apache.poi.openxml4j.exceptions.InvalidFormatException;

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

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

import org.apache.poi.ss.usermodel.Sheet;

import org.apache.poi.ss.usermodel.Workbook;

import org.apache.poi.ss.usermodel.WorkbookFactory;

public class ReadFromExcelSheet

 {

public static void main(String[] args) throws EncryptedDocumentException, InvalidFormatException, IOException 

{

String str="D:\\excel\\Book1.xlsx";

FileInputStream file=new FileInputStream(str);

Workbook book = WorkbookFactory.create(file);

Sheet sheet = book.getSheetAt(0);

for (int rowIndex = 0; rowIndex <= sheet.getLastRowNum(); rowIndex++)

{

  Row row = sheet.getRow(rowIndex);

  if (row != null) 

  {

  for(int colIndex=0; colIndex <row.getLastCellNum();colIndex++)

  {

  Cell cell = row.getCell(colIndex);

    if (cell != null) 

    {

      String cellValueMaybeNull = cell.getStringCellValue();

      System.out.print(cellValueMaybeNull+"\t");

    }

  }

  System.out.println();

  }

}

}

}

output:

userName1 password1

userName2 password2

userName3 password3

userName4 password4

userName5 password5

userName6 password6

userName7 password7

userName8 password8

userName9 password9

userName10 password10

userName11 password11

userName12 password12

userName13 password13

userName14 password14

userName16 password16