新版excel优化

chenjiahe

2023-10-08 8b3e27cbc244bc5e09ea1acd8a0a0546927e063d

 src/main/java/com/hx/util/SimpleTool.java

@@ -43,6 +43,7 @@
import net.sourceforge.pinyin4j.PinyinHelper;
import net.sourceforge.pinyin4j.format.HanyuPinyinOutputFormat;
import net.sourceforge.pinyin4j.format.HanyuPinyinToneType;
import org.apache.poi.ss.usermodel.CellType;
import org.springframework.cglib.beans.BeanMap;

public class SimpleTool {
@@ -802,7 +803,7 @@
            HSSFCell cell = hssfrow.getCell(i);
            if (cell == null) {
               arrayString[i] = "";
            } else if (cell.getCellType() == 0) {
            } else if (cell.getCellType() == CellType.NUMERIC) {
               // arrayString[i] = new Double(cell.getNumericCellValue()).toString();
                short format = cell.getCellStyle().getDataFormat();  
                   SimpleDateFormat sdf = null;  
@@ -812,7 +813,7 @@
                   }else if (format == 20 || format == 32) {  
                       //时间  
                       sdf = new SimpleDateFormat("HH:mm");  
                   }else if (HSSFCell.CELL_TYPE_NUMERIC == cell.getCellType()) { 
                   }else if (CellType.NUMERIC == cell.getCellType()) {
                    if (HSSFDateUtil.isCellDateFormatted(cell)) {    
                      Date d = cell.getDateCellValue();    
                      DateFormat formater = new SimpleDateFormat("yyyy年"); 
@@ -868,9 +869,9 @@
                  HSSFCell cell = hssfrow.getCell(i);
                  if (cell == null) {
                     arrayString[i] = "";
                  } else if (cell.getCellType() == 0) {
                  } else if (cell.getCellType() == CellType.NUMERIC) {
                     // arrayString[i] = new Double(cell.getNumericCellValue()).toString();
                     if (HSSFCell.CELL_TYPE_NUMERIC == cell.getCellType()) {
                     if (CellType.NUMERIC == cell.getCellType()) {
                        short format = cell.getCellStyle().getDataFormat();  
                        if(format == 14 || format == 31 || format == 57 || format == 58){  
                           //日期（中文时间格式的）
@@ -884,17 +885,17 @@
                           // DateFormat formater = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
                           arrayString[i] = formater.format(d);   
                        } else {    
                           if(HSSFCell.CELL_TYPE_STRING == cell.getCellType()){
                           if(CellType.STRING == cell.getCellType()){
                              arrayString[i] =cell.getStringCellValue();
                           }else if(HSSFCell.CELL_TYPE_FORMULA==cell.getCellType()){
                           }else if(CellType.FORMULA==cell.getCellType()){
                              arrayString[i] =cell.getCellFormula();
                           }else if(HSSFCell.CELL_TYPE_NUMERIC== cell.getCellType()){
                           }else if(CellType.NUMERIC== cell.getCellType()){
                              HSSFDataFormatter dataFormatter = new HSSFDataFormatter();
                              arrayString[i] =dataFormatter.formatCellValue(cell);
                           }
                        }
                     }
                  } else if(cell.getCellType() == Cell.CELL_TYPE_BLANK){
                  } else if(cell.getCellType() == CellType.BLANK){
                     arrayString[i] = "";
                  } else { // 如果EXCEL表格中的数据类型为字符串型
                     arrayString[i] = cell.getStringCellValue().trim();
@@ -939,9 +940,9 @@
                     HSSFCell cell = hssfrow.getCell(i);
                     if (cell == null) {
                        arrayString[i] = "";
                     } else if (cell.getCellType() == 0) {
                     } else if (cell.getCellType() == CellType.NUMERIC) {
                        // arrayString[i] = new Double(cell.getNumericCellValue()).toString();
                        if (HSSFCell.CELL_TYPE_NUMERIC == cell.getCellType()) {
                        if (CellType.NUMERIC == cell.getCellType()) {
                           short format = cell.getCellStyle().getDataFormat();  
                           if(format == 14 || format == 31 || format == 57 || format == 58){  
                              //日期（中文时间格式的）
@@ -955,20 +956,20 @@
                              // DateFormat formater = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
                              arrayString[i] = formater.format(d);   
                           } else {    
                              if(HSSFCell.CELL_TYPE_STRING == cell.getCellType()){
                              if(CellType.STRING == cell.getCellType()){
                                 arrayString[i] =cell.getStringCellValue();
                              }else if(HSSFCell.CELL_TYPE_FORMULA==cell.getCellType()){
                              }else if(CellType.FORMULA==cell.getCellType()){
                                 arrayString[i] =cell.getCellFormula();
                              }else if(HSSFCell.CELL_TYPE_NUMERIC== cell.getCellType()){
                              }else if(CellType.NUMERIC== cell.getCellType()){
                                 HSSFDataFormatter dataFormatter = new HSSFDataFormatter();
                                 arrayString[i] =dataFormatter.formatCellValue(cell);
                              }
                           }
                        }
                     } else if(cell.getCellType() == Cell.CELL_TYPE_BLANK){
                     } else if(cell.getCellType() == CellType.BLANK){
                        arrayString[i] = "";
                     } else { // 如果EXCEL表格中的数据类型为字符串型
                        cell.setCellType(Cell.CELL_TYPE_STRING);
                        cell.setCellType(CellType.STRING);
                        String name = cell.getStringCellValue().trim();
                        if(name.equals("-")) {
                           arrayString[i] = "";