关于excel 导出导入 的相关POI 使用

一：excel 的文件导入 

    页面导入文件 

    由前端界面将文件接受 后端接受到传来的InputStream inp  参数 

    或者 是通过文件地址获取的 InputStream inp =  new FileInputStream(realPath);

    创建对象Workbook wb = WorkbookFactory.create(inp);

         wb  =     new XSSFWorkbook(inp);//xlsx后缀

         wb  =     new HSSFWorkbook(inp);//xls 后缀

    读取sheet ：1.通过索引读取Sheet sheet = wb.getSheetAt(0);

                        2.通过sheet名读取Sheet sheet = wb.getSheet(sheetName);

    循环读取 sheet 

                       List<HashMap<String, Object>> result = new ArrayList<HashMap<String, Object>>();

                         for(Row row : sheet) {

map = new HashMap<String, Object>();
//表头跳过
if(row.getRowNum() < 1) {
continue;
}

if(POIExcelUtil.getStringValueFromCell(row.getCell(0)) == "") {

continue;//跳过空行
}
map.put("param1", POIExcelUtil.getStringValueFromCell(row.getCell(0)));
map.put("param2", POIExcelUtil.getStringValueFromCell(row.getCell(1)));
map.put("param3", POIExcelUtil.getStringValueFromCell(row.getCell(2)));
map.put("param4", POIExcelUtil.getStringValueFromCell(row.getCell(3)));

result.add(map);

                    }最终获取 excel的list<HashMap<String, Object>>的集合  result