admin 管理员组

文章数量: 1087576

Java Aspose导入导出excel

    

 导出模板如上图

实体类:

	/** 主键 */private String id;/** 班级名称 */private String name;/** 班级人数 */private String num;
/*** 导出Excel数据* @param query* @return* @throws Exception*/public InputStream exportBwClass(BwClass query) throws Exception{// 导出路径String logPath = "D:" + File.separator + "excel" + File.separator + "bwClassExport" + File.separator + "";File file = new File(logPath);if (!file.exists()){file.mkdirs();}// 模板路径String FilePath = "D:" + File.separator + "excel" + File.separator + "Template.xlsx";InputStream in = null;Workbook wb = null;try{in = new FileInputStream(new File(FilePath));// 读取工作簿wb = new Workbook(in);}finally{// 关闭输入流in.close();}// 创建Aspose.Cells WorkbookDesigner 的对象WorkbookDesigner designer = new WorkbookDesigner();designer.setWorkbook(wb);// 构建DataSourceList<BwClass> rList = queryList(query);designer.setDataSource("a", rList);// 根据数据源处理生成报表内容designer.process();// 输出流，写入到文件中String tempFile = BwClassConstant.TEMP_EXCEL;OutputStream out = new FileOutputStream(tempFile);try{// 保存数据wb.save(out, wb.getFileFormat());FileInputStream inputStream = new FileInputStream(tempFile);return inputStream;}finally{out.close();}}


 

/*** 保存导入excel*/@Overridepublic ResponseDto saveImport(HttpServletRequest request, InputStream in){ResponseDto dto = new ResponseDto();// 1、打开文件，参数可以是文件的路径，也可以直接传入一个文件流Workbook workbook = null;try{workbook = new Workbook(in);}catch (Exception e){LOG.error(e.getMessage(), e);throw new NormalRuntimeException(e.getMessage());}// 2、获取sheet表WorksheetCollection worksheets = workbook.getWorksheets();Worksheet worksheet = worksheets.get(0);Cells cells = worksheet.getCells();List<BwClass> addList = new ArrayList<BwClass>();for (int i = 1; i < cells.getMaxRow() + 1; i++){int j = 0;if (StringUtil.isEmpty(cells.get(i, j).getStringValue())){throw new NormalRuntimeException("班级id不能为空");}BwClass bwClass = new BwClass(cells.get(i, j).getStringValue(), cells.get(i, j + 1).getStringValue(), cells.get(i, j + 2).getStringValue());bwClass.setCreateTime(new Date());if (bwClass != null){addList.add(bwClass);}}try{bwClassDao.batchCreate(addList, "insert");dto.setSuccesResultObj("导入成功");}catch (Exception e){dto.setErrMsg("导入失败！");LOG.error(e.getMessage(), e);}worksheets.clear();worksheet = null;worksheets = null;workbook = null;return dto;}

本文标签： Java Aspose导入导出excel

版权声明：本文标题：Java Aspose导入导出excel 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.roclinux.cn/p/1700324025a397030.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。