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

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;
import org.apache.poi.ss.usermodel.Row;

public class ReadExcelFile {

	public static final String EXCEL_FILE = "C:/Test.xls";

	public static void readXLSFile() {
		try {
			InputStream ExcelFileToRead = new FileInputStream(EXCEL_FILE);
			HSSFWorkbook wb = new HSSFWorkbook(ExcelFileToRead);

			HSSFSheet sheet = wb.getSheetAt(0);
			HSSFRow row;
			HSSFCell cell;

			Iterator rows = sheet.rowIterator();

			while (rows.hasNext()) {
				row = (HSSFRow) rows.next();
				Iterator cells = row.cellIterator();

				while (cells.hasNext()) {
					cell = (HSSFCell) cells.next();
					System.out.print(cell.toString()+" ");
				}
				System.out.println();
			}

		} catch (Exception e) {
			e.printStackTrace();
		}

	}

	public static void readXLSFileWithBlankCells() {
		try {
			InputStream ExcelFileToRead = new FileInputStream(EXCEL_FILE);
			HSSFWorkbook wb = new HSSFWorkbook(ExcelFileToRead);

			HSSFSheet sheet = wb.getSheetAt(0);
			HSSFRow row;
			HSSFCell cell;

			Iterator rows = sheet.rowIterator();

			while (rows.hasNext()) {
				row = (HSSFRow) rows.next();

				for(int i=0; i<row.getLastCellNum(); i++) {
					cell = row.getCell(i, Row.CREATE_NULL_AS_BLANK);
					System.out.print(cell.toString()+" ");
				}
				System.out.println();
			}

		} catch (Exception e) {
			e.printStackTrace();
		}

	}

	public static void main(String[] args) {
		readXLSFile();
		readXLSFileWithBlankCells();
	}

}