easypoi-单sheet页导入导出

maven:

<dependency>
				<groupId>cn.afterturn</groupId>
				<artifactId>easypoi-base</artifactId>
				<version>3.0.3</version>
			</dependency>
			<dependency>
				<groupId>cn.afterturn</groupId>
				<artifactId>easypoi-web</artifactId>
				<version>3.0.3</version>
			</dependency>
			<dependency>
				<groupId>cn.afterturn</groupId>
				<artifactId>easypoi-annotation</artifactId>
				<version>3.0.3</version>
			</dependency>

 

环境SSM,jdk1.8    要看多sheet页的导入导出  看我上一篇博客

 

一、导入

@RequestMapping(value = "excelImport")
	@ResponseBody
	public  Object save(MultipartFile file) {
		try {
			ImportParams params = new ImportParams();
			params.setTitleRows(0);
			//是否要验证
			params.setNeedVerfiy(true);
			//验证与转换数据成类
			ExcelImportResult<SalaryVO> result = ExcelImportUtil.importExcelMore(file.getInputStream(), SalaryVO.class, params);
			//把验证合格的数据存入数据库
			CallServiceUtil.callDataService("encryptionSalaryService", "excelImport", new Object[] { result.getList() },
						new Class[] { List.class });
			//错误信息的载体
			StringBuilder sb=new StringBuilder();
			//是否有不合规定的数据
			if(result.isVerfiyFail()){
				//拼错误信息给页面
				for(SalaryVO s : result.getFailList()){
					sb.append(s.getRealName()+",");
				}
				sb.append("的绩效信息有误");
				return renderError(sb.toString());
			}
		} catch (Exception e) {
			e.printStackTrace();
			return renderError("导入失败！请检查导入文档的格式是否正确");
		}
		return renderSuccess("导入成功！");
	}

 

二、导出

@RequestMapping(value = "excelExport")  
    public void excelExport(HttpServletResponse response,@RequestParam Map<String, Object> params) throws IOException{  
        List list=CallServiceUtil.callDataService("encryptionSalaryService", "excelExport", new Object[]{params},   
                   new Class[]{Map.class});// 查询所有的数据  
        ExportParams param=new ExportParams();
        Workbook workbook =ExcelExportUtil.exportExcel(param,SalaryVO.class,list); 
        ExcelUtil.downloadExcel(response, workbook, "薪酬信息");
    }

ExcelUtil工具类在上一篇   多sheet导入导出的文章里