这几天做一个二期项目 用到导出功能 下面就简单聊聊吧 废话不多 上代码 实体类
@Data public class Label { //定义的导出字段 private String fatherName; private String name; private int fatherId; private int id; }execl简单工具类 因为 我的数据都有值就没做非空判断 `
public class ExcelUtil { /** * 将数据到excel文件中去 * * */ public static void exportUserExcel(List<Label> labelList) { try{ //1.创建工作簿 HSSFWorkbook workbook = new HSSFWorkbook(); File file = new File("D://信息.xls"); FileOutputStream fileOutputStream = new FileOutputStream(file); HSSFSheet sheet = workbook.createSheet(); //3.2创建列标题;并且设置列标题 HSSFRow row = sheet.createRow(0); String[] titles = {"父节点名称","父节点id","子节点名称","子节点id"}; for(int i=0;i<titles.length;i++) { HSSFCell cell = row.createCell(i); cell.setCellValue(titles[i]); } //4.操作单元格;将用户列表写入excel if(labelList != null) { for(int j=0;j<labelList.size();j++) { //创建数据行,前面有两行,头标题行和列标题行 HSSFRow row3 = sheet.createRow(j+1); HSSFCell cell1 = row3.createCell(0); cell1.setCellValue(labelList.get(j).getFatherName()); HSSFCell cell2 = row3.createCell(1); cell2.setCellValue(labelList.get(j).getFatherId()); HSSFCell cell3 = row3.createCell(2); cell3.setCellValue(labelList.get(j).getName()); HSSFCell cell4 = row3.createCell(3); cell4.setCellValue(labelList.get(j).getId()); } } workbook.close(); }catch(Exception e) { e.printStackTrace(); } } }service实现类
@Override public int toExecl() { List<Label> info = torderLabelMapper.getInfo(); ExcelUtil.exportUserExcel(info); return 1; }controller 层
@GetMapping("/toExecl") public int toExcel(){ return orderLabelService.toExecl(); }如果有不对的，欢迎大佬指教 我小菜鸟一枚 请大家多多包涵 想看execl 导入请移步到 [https://blog.csdn.net/weixin_45810063/article/details/108382756]
