String strValue = null;
if(cell instanceof HSSFCell){
HSSFCell hssfCell = (HSSFCell)cell;
if(HSSFDateUtil.isCellDateFormatted(hssfCell)){
// Date date = HSSFDateUtil.getJavaDate(dv);
HSSFCellStyle cellStyle = hssfCell.getCellStyle();
if(cellStyle!=null && cellStyle.getDataFormatString()!=null){
String dateFmt = cell.getCellStyle().getDataFormatString();
/* strValue = new SimpleDateFormat(dateFmt).format(date); - won't work as
Java fmt differs from Excel fmt. If Excel date format is mm/dd/yyyy, Java
will always be 00 for date since "m" is minutes of the hour.*/
strValue = new CellDateFormatter(dateFmt).format(hssfCell.getDateCellValue());
}else{
strValue = WebVariable.sdf.format(hssfCell.getDateCellValue());
}
// td.text(strValue);
}else{
HSSFCellStyle cellStyle = hssfCell.getCellStyle();
if(cellStyle!=null && cellStyle.getDataFormatString()!=null){
// String dataFmt = cellStyle.getDataFormatString();
strValue = new HSSFDataFormatter().formatRawCellContents(hssfCell.getNumericCellValue(), cellStyle.getDataFormat(), cellStyle.getDataFormatString());
}else{
strValue = String.valueOf(hssfCell.getNumericCellValue());
}
}
}else{
XSSFCell xssfCell = (XSSFCell)cell;
if(HSSFDateUtil.isCellDateFormatted(cell)){
String dateFmt = cell.getCellStyle().getDataFormatString();
/* strValue = new SimpleDateFormat(dateFmt).format(date); - won't work as
Java fmt differs from Excel fmt. If Excel date format is mm/dd/yyyy, Java
will always be 00 for date since "m" is minutes of the hour.*/
strValue = new CellDateFormatter(dateFmt).format(cell.getDateCellValue());
// td.text(strValue);
}else{
XSSFCellStyle cellStyle = xssfCell.getCellStyle();
if(cellStyle!=null && cellStyle.getDataFormatString()!=null){
// String dateFmt = cell.getCellStyle().getDataFormatString();
/* strValue = new SimpleDateFormat(dateFmt).format(date); - won't work as
Java fmt differs from Excel fmt. If Excel date format is mm/dd/yyyy, Java
will always be 00 for date since "m" is minutes of the hour.*/
strValue = new HSSFDataFormatter().formatRawCellContents(cell.getNumericCellValue(), cellStyle.getDataFormat(), cellStyle.getDataFormatString());
}else{
strValue = String.valueOf(xssfCell.getNumericCellValue());
}
// xssfCell.getCellStyle().getDataFormatString();
// td.text(String.valueOf(cell.getNumericCellValue()));
}
}
td.text(strValue);
}else if(cell.getCellType()==Cell.CELL_TYPE_STRING){
td.text(cell.getStringCellValue());
}
if(sheet instanceof HSSFSheet){
HSSFSheet hssfSheet = (HSSFSheet)sheet;
HSSFCell hssfCell = (HSSFCell)cell;
HSSFCellStyle style = hssfCell.getCellStyle();
// 判断一下如果式样中有斜杠，那么写一个斜杠
HSSFPalette palette = hssfSheet.getWorkbook().getCustomPalette();
styleApplier4XLS(td,style,hssfSheet.getWorkbook(),palette);
}else{