Women in Technology

HSSFRow row = newXREFSheet.getRow(rowNo);
if (row != null) {
HSSFCell cell = row.getCell((short) col);
if (cell != null) {
switch (cell.getCellType()) {
case HSSFCell.CELL_TYPE_NUMERIC:
HSSFCellStyle style = cell.getCellStyle();
if(style.getIndex() == 35){
cellVal = cell.getDateCellValue().toString();
String date = new SimpleDateFormat("MM/dd/yyyy").
format(new SimpleDateFormat("EEE MMM dd HH:mm:ss zzz yyyy").parse(cellVal.toString()));
cellVal = date;
}
else{
cellVal = String.valueOf(cell.getNumericCellValue());
}
break;
case HSSFCell.CELL_TYPE_STRING:
cellVal = cell.getStringCellValue();
break;
case HSSFCell.CELL_TYPE_FORMULA:
cellValDoub = cell.getNumericCellValue();
df = new DecimalFormat("##");
cellVal = df.format(cellValDoub).toString();

break;
default:

break;
}
}
}