poi无实体类导入excel

@ResponseBody
@RequestMapping(value = “upload”, method = {RequestMethod.GET, RequestMethod.POST})
public Object importExcel(@RequestParam(“file”) MultipartFile file) {
try {

        if (file != null && file.getSize() > 0) {

            //返回的第一条数据是表头信息
            List<String[]> data = GhPOIUtils.readExcel(file);

            //data 解析出来的excel数据， list第一条数据是表头数据，第二条数据开始为     表头下的内容
            return new Result();
        }

        return new Result(-1, "文件为空", "");

    } catch (BaseException e) {
        return new Result(-1, e.getMessage(), "");
    } catch (Exception e) {
        return new Result(-1, "系统异常", "");
    }

}


--------------------工具类----------------------------------------


public class GhPOIUtils {
public static Workbook getWorkBook(MultipartFile file) {

    //创建Workbook工作薄对象，表示整个excel
    Workbook workbook = null;
    try {
        //获取excel文件的io流
        InputStream is = file.getInputStream();

        workbook = WorkbookFactory.create(is);
    } catch (InvalidFormatException e) {
        e.printStackTrace();
    } catch (IOException e) {
        e.printStackTrace();
    }
    return workbook;
}

public static String getCellValue(Cell cell) {
    String cellValue = "";
    if (cell == null) {
        return cellValue;
    }
    //把数字当成String来读，避免出现1读成1.0的情况
    if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
        cell.setCellType(Cell.CELL_TYPE_STRING);
    }
    //判断数据的类型
    switch (cell.getCellType()) {
        case Cell.CELL_TYPE_NUMERIC: //数字
            cellValue = String.valueOf(cell.getNumericCellValue());
            break;
        case Cell.CELL_TYPE_STRING: //字符串
            cellValue = String.valueOf(cell.getStringCellValue());
            break;
        case Cell.CELL_TYPE_BOOLEAN: //Boolean
            cellValue = String.valueOf(cell.getBooleanCellValue());
            break;
        case Cell.CELL_TYPE_FORMULA: //公式
            cellValue = String.valueOf(cell.getCellFormula());
            break;
        case Cell.CELL_TYPE_BLANK: //空值
            cellValue = "";
            break;
        case Cell.CELL_TYPE_ERROR: //故障
            cellValue = "非法字符";
            break;
        default:
            cellValue = "未知类型";
            break;
    }
    return cellValue;
}


/**
 * 读入excel文件，解析后返回
 * @param file excel 文件
 * @return  list中的每个数组是每一行excel，list中的第一条数据是excel的表头，其余之后的是excel中的数据
 */
public static List<String[]> readExcel(MultipartFile file) throws IOException {

    //获得Workbook工作薄对象
    Workbook workbook = getWorkBook(file);
    //创建返回对象，把每行中的值作为一个数组，所有行作为一个集合返回
    List<String[]> list = new ArrayList<String[]>();
    if (workbook != null) {
        //只读取第一个sheet页
        for (int sheetNum = 0; sheetNum < 1; sheetNum++) {
            //获得当前sheet工作表
            Sheet sheet = workbook.getSheetAt(sheetNum);
            if (sheet == null) {
                continue;
            }
            //获得当前sheet的开始行
            int firstRowNum = sheet.getFirstRowNum();
            //获得当前sheet的结束行
            int lastRowNum = sheet.getLastRowNum();
            //循环所有行
            for (int rowNum = firstRowNum; rowNum <= lastRowNum; rowNum++) {
                //获得当前行
                Row row = sheet.getRow(rowNum);
                if (row == null) {
                    continue;
                }
                //获得当前行的开始列
                int firstCellNum = row.getFirstCellNum();
                //获得当前行的列数
                int lastCellNum;
                if (rowNum == 0){
                    lastCellNum = row.getPhysicalNumberOfCells();
                }else {
                    lastCellNum = list.get(0).length;
                }
                String[] cells = new String[lastCellNum];  //需要更改  是数组长度  “row.getPhysicalNumberOfCells()”
                //循环当前行
                for (int cellNum = firstCellNum; cellNum < lastCellNum; cellNum++) { //需要更改循环长度 “lastCellNum”
                    Cell cell = row.getCell(cellNum);
                    cells[cellNum] = getCellValue(cell);
                }
                list.add(cells);
            }
        }
        workbook.close();
    }
    return list;
}

}