import java.io.FileInputStream;

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.Cell;

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

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

public class Project03_C {

public static void main(String[] args) {

String fileName="cellDataType.xls";

try(FileInputStream fis=new FileInputStream(fileName)) {

HSSFWorkbook workbook=new HSSFWorkbook(fis);

HSSFSheet sheet=workbook.getSheetAt(0);

Iterator<Row> rows=sheet.rowIterator();

while(rows.hasNext()) {

HSSFRow row=(HSSFRow) rows.next();

Iterator<Cell> cells=row.cellIterator();

while(cells.hasNext()) {

HSSFCell cell=(HSSFCell) cells.next();

CellType type=cell.getCellType();

if(type==CellType.STRING) {

System.out.println("["+cell.getRowIndex()+","

+ cell.getColumnIndex()+"] = STRING; Value="

+ cell.getRichStringCellValue().toString());

}else if(type==CellType.NUMERIC) {

System.out.println("["+cell.getRowIndex()+","

+ cell.getColumnIndex()+"] = NUMERIC; Value="

+ cell.getNumericCellValue());

}else if(type==CellType.BOOLEAN) {

System.out.println("["+cell.getRowIndex()+","

+ cell.getColumnIndex()+"] = BOOLEAN; Value="

+ cell.getBooleanCellValue());

}else if(type==CellType.BLANK) {

System.out.println("["+cell.getRowIndex()+","

+ cell.getColumnIndex()+"] = BLANK CELL");

}

}

}

} catch (Exception e) {

e.printStackTrace();

}

}

}