Excel数据在(jsp+ssh)环境下导入导出.docxVIP

//检查excel中解析的数据格式privatestatic String getCellValue(HSSFCell cell){ String value = null; if(cell==null)//如果最后两列值为空，此时cell.getCellType()会报空指针异常，令其返回值为空 {value = ; return value; }//简单的查检列类型else {switch(cell.getCellType()) { case HSSFCell.CELL_TYPE_STRING://字符串 value = cell.getRichStringCellValue().getString(); break; case HSSFCell.CELL_TYPE_NUMERIC://数字long dd = (long)cell.getNumericCellValue(); value = dd+; break; case HSSFCell.CELL_TYPE_BLANK: value = ; break; case HSSFCell.CELL_TYPE_FORMULA: