Java POI 导入Excel时对Excel数据进行格式转换

本文主要内容是使用Java POI对Excel导入时，对Excel的数据形式进行格式转换。

下面是代码

    Sheet sheet = workbook.getSheetAt(0);
    int rowCount = sheet.getPhysicalNumberOfRows();
    Row row0 = sheet.getRow(0);
    int cellCount = row0.getPhysicalNumberOfCells();
    for (int i = 1; i < rowCount; i++) {
        // 读取左上端单元格
        Row row = sheet.getRow(i);
        if (row != null) {
            String[] val = new String[cellCount];
            for (int j = 0; j < cellCount; j++) {
                Cell cell = row.getCell(j);
                String value = "";
                if (cell != null) {
                    switch (cell.getCellType()) {
                        case HSSFCell.CELL_TYPE_FORMULA:
                            break;
                        case HSSFCell.CELL_TYPE_NUMERIC:
                            cell.setCellType(Cell.CELL_TYPE_STRING);
                            // 防止把1 取成1.0
                            value = cell.getStringCellValue();
                            break;
                        case HSSFCell.CELL_TYPE_STRING:
                            value = cell.getRichStringCellValue().getString();
                            break;
                        default:
                            value = "";
                            break;
                    }
                } else {
                    value = "";
                }
                val[j] = value;
            }
        }
    }