import java.io.File;
import java.io.FileInputStream;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class ReadingDataFromExcel{
public static void main(String args[]){
        FileInputStream fis=null;
        File f=null;
        HSSFWorkbook wb =  null;
        try{
            f=new File("C:\\sample.xls");
            fis=new FileInputStream(f);
            wb =  new HSSFWorkbook(fis);
        }catch(Exception e){
            System.out.println("error while getting the file...");
        }
        
        HSSFSheet sheet = wb.getSheet("Sheet1");
        System.out.println("Values from Sheet1 : ");
        
        int lastRowNo=sheet.getLastRowNum();
        for(int rowNo=0;rowNo<=lastRowNo;rowNo++){
        	HSSFRow row=sheet.getRow(rowNo);
        	int lastCellNo=row.getLastCellNum();
        	for(short colNo=0;colNo<lastCellNo;colNo++){
        		HSSFCell cell=row.getCell(colNo);
        		if(cell.getCellType()==HSSFCell.CELL_TYPE_NUMERIC){
        			System.out.print(cell.getNumericCellValue()+"\t");
        		}else if(cell.getCellType()==HSSFCell.CELL_TYPE_STRING){
        			System.out.print(cell.getStringCellValue()+"\t");
        		}else{
        			System.out.println("Cell type not found");
        		}//else
        	}//for(short colNo=0;..
        	System.out.println("");
        }//for
        
        try{
        	fis.close();
        }catch (Exception e) {
			e.printStackTrace();
		}//catch
    }//main
}//class