Read Excel File Using Apache POI

Here is some nice code snippet to read Excel file using Apache POI Api.
Download Apache POI form here
Create a project in eclipse and add following jars in your classpath. (Not all are required for this example)
poi-3.8-20120326.jar
poi-examples-3.8-20120326.jar
poi-excelant-3.8-20120326.jar
poi-ooxml-3.8-20120326.jar
poi-ooxml-schemas-3.8-20120326.jar
poi-scratchpad-3.8-20120326.jar
commons-logging-1.1.jar
junit-3.8.1.jar
log4j-1.2.13.jar

package com.bharat.poi;

package com.bharat.poi;

import java.io.FileInputStream;
import java.util.ArrayList;
import java.util.Iterator;

import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ReadExcelFile
{
  public static void main(String... args)
  {
    // name of Excel file you want to read.
    String fileName = "bond-2-8.xlsx";
    
    // Read an Excel File and Store in an ArrayList
    ArrayList<ArrayList<XSSFCell>> dataHolder = readExcelFile(fileName);
    
    // Print the data read
    printCellDataToConsole(dataHolder);
  }

  public static ArrayList<ArrayList<XSSFCell>> readExcelFile(String fileName)
  {
    /**
     * --Define a List --Holds List Of Cells
     */
    ArrayList<ArrayList<XSSFCell>> cellListHolder =
        new ArrayList<ArrayList<XSSFCell>>();

    try
    {
      /* Creating Input Stream */
      FileInputStream myInput = new FileInputStream(fileName);

      /* Create a workbook using Stream */
      XSSFWorkbook myWorkBook = new XSSFWorkbook(myInput);

      /* Get the first sheet from workbook */
      XSSFSheet mySheet = myWorkBook.getSheetAt(0);

      /* iterate through the cells. */
      
      Iterator rowIter = mySheet.rowIterator();

      while (rowIter.hasNext())
      {
        XSSFRow myRow = (XSSFRow) rowIter.next();
        Iterator cellIter = myRow.cellIterator();
        ArrayList<XSSFCell> cellStoreList = new ArrayList<XSSFCell>();
        while (cellIter.hasNext())
        {
          XSSFCell cell = (XSSFCell) cellIter.next();
          cellStoreList.add(cell);
        }
        cellListHolder.add(cellStoreList);
      }
    }
    catch (Exception e)
    {
      e.printStackTrace();
    }
    return cellListHolder;
  }

  /**
   * prints data to console
   * 
   * @param dataHolder
   */
  private static void printCellDataToConsole(ArrayList<ArrayList<XSSFCell>> dataHolder)
  {

    for(ArrayList<XSSFCell> cellList : dataHolder)
    {
      for(XSSFCell cell: cellList)
      {
        String stringCellValue = cell.toString();
        System.out.print(stringCellValue +"\t");
      }
      System.out.println();
    }

  }
}