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 rows=sheet.rowIterator();
while(rows.hasNext()) {
HSSFRow row=(HSSFRow) rows.next();
Iterator| 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();
}
}
}
|