springboot实现导出excel

最新推荐文章于 2024-05-22 22:49:25 发布
最新推荐文章于 2024-05-22 22:49:25 发布
阅读量168 收藏
点赞数
文章标签： java 前端 ViewUI
原文链接：http://www.cnblogs.com/thcy1314/p/10696526.html
版权

一.添加导出工具类

/** 
 * Project Name:vphotoSaaS 
 * File Name:ExcelDownloadUtil.java 
 * Package Name:com.v.photos.action 
 * Date:2016年8月26日上午11:10:32 
 * Copyright (c) 2016, VPhoto All Rights Reserved. 
 * 
 */  
package com.v.photos.action;

import com.v.photos.services.core.ErrorCode;
import com.v.photos.services.core.NestedRuntimeException;
import jxl.Workbook;
import jxl.format.Colour;
import jxl.format.VerticalAlignment;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import org.apache.commons.beanutils.PropertyUtils;
import org.apache.commons.collections.MapUtils;

import javax.servlet.http.HttpServletResponse;
import java.io.OutputStream;
import java.net.URLEncoder;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.Collection;
import java.util.Date;
import java.util.LinkedHashMap;
import java.util.Map;
import java.util.Map.Entry;

/**
 * @author scy
 *
 */
public class ExcelDownloadUtil {


   public static void downloadUtil(HttpServletResponse response,String excelName,LinkedHashMap<String,String> columnMap,Collection dataList){
      downloadUtil(response, excelName, columnMap, dataList,null,null);
   }

   public static void downloadUtil(HttpServletResponse response,String excelName,LinkedHashMap<String,String> columnMap,Collection dataList,Map<String,String> dictMap,Map<String,String> nullDefault){
      downloadUtil(response, excelName, columnMap, dataList, dictMap, nullDefault, null);
   }

   public static void downloadUtil(HttpServletResponse response, String excelName, LinkedHashMap<String,String> columnMap, Collection dataList, Map<String,String> dictMap, Map<String,String> nullDefault, Map<Integer, Colour> colourMap){
      try{
         OutputStream os = response.getOutputStream(); // 取得输出流
         response.reset(); // 清空输出流
         response.setCharacterEncoding("UTF-8");
         response.setHeader("Content-disposition", "attachment; filename=" + URLEncoder.encode(excelName+".xls", "UTF-8")); // 设定输出文件头
         response.setContentType("application/msexcel"); // 定义输出类型
         getOutputStream(os, columnMap, dataList, dictMap, nullDefault, colourMap);
         os.close();
      }catch(Exception e){
         e.printStackTrace();
         throw new NestedRuntimeException(ErrorCode.ACTION_FILE_DOWNLOAD_ERROR);          
      }
   }

   public static void getOutputStream(OutputStream os, LinkedHashMap<String,String> columnMap, Collection dataList, Map<String,String> dictMap, Map<String,String> nullDefault, Map<Integer, Colour> colourMap) throws Exception{
      String[] titles = new String[columnMap.size()];
      String[] columns = new String[columnMap.size()];

      SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
      DecimalFormat decimal = new DecimalFormat("0.00");
      int f = 0;
      for (Entry<String,String> entry : columnMap.entrySet()) {
         titles[f] = entry.getValue();
         columns[f] = entry.getKey();
         f++;
      }

      WritableWorkbook workbook = Workbook.createWorkbook(os);
      WritableSheet wsheet = workbook.createSheet("sheet1", 0);
      WritableFont font = new WritableFont(WritableFont.ARIAL, 12, WritableFont.BOLD, false,
            jxl.format.UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLACK);
      WritableCellFormat format = new WritableCellFormat(font);
      for (int i = 0; i < titles.length; i++) {
         Label wlabel1 = new Label(i, 0, String.valueOf(titles[i]), format); // 行、列、单元格中的文本、文本格式
         wsheet.addCell(wlabel1);
      }
      font = new WritableFont(WritableFont.createFont("宋体"), 12, WritableFont.NO_BOLD, false,
            jxl.format.UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLACK);
      format = new WritableCellFormat(font);

      for (int i = 0; i < titles.length; i++) {
         wsheet.setColumnView(i, 25);// 设置宽度             
      }

      WritableCellFormat bgYellowFormat = new WritableCellFormat(font);
      bgYellowFormat.setVerticalAlignment(VerticalAlignment.CENTRE);
      bgYellowFormat.setBackground(Colour.YELLOW);

      WritableCellFormat defaultFormat = format;

      f = 1;
      Integer index;
      for (Object obj : dataList) {
         for (int i = 0; i < columns.length; i++) {
            String columnName = columns[i];
            try{
               Object val = null;
               if(obj instanceof Map){
                  Map objMap = (Map) obj;
                  val = objMap.get(columnName);

                  index = MapUtils.getInteger(objMap, "index");
                  if (index != null && index % 2 == 0) {
                     defaultFormat = bgYellowFormat;
                  } else {
                     defaultFormat = format;
                  }

                  if (MapUtils.isNotEmpty(colourMap)) {
                     Colour colour = colourMap.get(f-1);
                     if (colour != null) {
                        WritableCellFormat colourFormat = new WritableCellFormat(font);
                        colourFormat.setVerticalAlignment(VerticalAlignment.CENTRE);
                        colourFormat.setBackground(colour);
                        defaultFormat = colourFormat;
                     }
                  }

               }else{
                  val = PropertyUtils.getNestedProperty(obj, columnName);
               }

               if(val != null){
                  if(dictMap!=null && dictMap.containsKey(columnName+"_"+val)){
                     val = dictMap.get(columnName+"_"+val);
                  }
               }else{
                  if(nullDefault!=null && nullDefault.containsKey(columnName)){
                     val = nullDefault.get(columnName);
                  }
               }

               if(val!=null && val instanceof Number){
                  jxl.write.Number test = new jxl.write.Number(i, f, val == null ? 0 : ((Number) val).doubleValue(), defaultFormat);
                  wsheet.addCell(test);
               }else{
                  if (val!=null && val instanceof Date) {
                     Date date = (Date) val;
                     val = df.format(date);
                  }else if (val!=null && val instanceof Double){
                     val = decimal.format(val);
                  }
                  Label wlabel1 = new Label(i, f, val==null?"":val.toString(), defaultFormat);
                  wsheet.addCell(wlabel1);
               }
            }catch(Exception e){
               e.printStackTrace();
            }
         }
         f++;
      }
      workbook.write(); // 写入文件
      workbook.close();
   }

}

 

二.controller层
/***
* 导出返佣日志信息，前端传ExportType=1,2,3
*或者直接写一个方法，只导出一种类型
* @param response
* @param record
* @return
*/

 /***
   * 导出返佣日志信息
   * @param response
   * @param record
   * @return
   */
  public void exportRebateLog(HttpServletResponse response, VBackLog record) {
      /*
   1：导出返佣日志列表
   2：导出返佣日志明细
   3：导出商品返佣明细
　　*/
      if (record.getExportType() != null && record.getExportType() > 0) {
          if (VBackLog.ExportTypeEnum.VBACKLOG.getId().equals(record.getExportType())) {
              iBackService.exportRebateLog(record, response);
          } else if (VBackLog.ExportTypeEnum.VBACKLOGDETAIL.getId().equals(record.getExportType())) {
              iBackService.exportRebateLogDetail(record, response);
          } else if (VBackLog.ExportTypeEnum.VBACKLOGORDERDETAIL.getId().equals(record.getExportType())) {
              iBackService.exportRebateLogOrderDetail(record, response);
          }
      }
  }

三.service层

/**
 * 导出返佣日志信息
 * @param response
 * @param record
 * @return
 */
void exportRebateLog(VBackLog record, HttpServletResponse response);

/**
 * 导出返佣日志明细信息
 * @param response
 * @param record
 * @return
 */
void exportRebateLogDetail(VBackLog record, HttpServletResponse response);

/**
 * 导出返佣日志商品信息
 * @param response
 * @param record
 * @return
 */
void exportRebateLogOrderDetail(VBackLog record, HttpServletResponse response);


四.serviceImpl层

/**
* 导出返佣日志信息
* 根据sql查询出来的去导出
*/
@Override
public void exportRebateLog(VBackLog record,HttpServletResponse response){
    LinkedHashMap<String, String> columnMap = new LinkedHashMap<>();
    columnMap.put("id", "ID");
    columnMap.put("waterNo", "批量操作号");
    columnMap.put("topUpCount", "涉及充值流水记录数");
    columnMap.put("customerName", "客户名称");
    columnMap.put("backType", "返佣类型");
    columnMap.put("month", "月季");
    columnMap.put("season", "季份");
    columnMap.put("year", "年份");
    columnMap.put("remark", "返佣说明");
    columnMap.put("topUpAmount", "充值金额");
    columnMap.put("backLevel", "返佣档位");
    columnMap.put("paymentTypeId", "用户结款类型");
    columnMap.put("rate", "返佣比例");
    columnMap.put("totalMoney", "本次返佣金额");
    columnMap.put("expenseId", "对应账户中心流水Id");
    columnMap.put("crDate", "创建时间");
    List<Map<String, Object>> dataList = new ArrayList<>();

    //查出返佣日志
    List<VBackLog> vBackLogList = findByVBackLog(record);
    if(CollectionUtils.isEmpty(vBackLogList)){
        throw new NestedRuntimeException(ErrorCode.VBACKLOG_ERROR, "返佣日志查询结果为空，无法导出，请核对查询条件是否有效");
    }
    for(VBackLog vBackLog:vBackLogList){
        Map<String, Object> dataMap = new HashMap<>();
        dataMap.put("id",vBackLog.getId());
        dataMap.put("waterNo", vBackLog.getWaterNo());
        dataMap.put("topUpCount", vBackLog.getTopUpCount());
        dataMap.put("customerName", vBackLog.getCustomerName());
        dataMap.put("backType", vBackLog.getBackType());
        dataMap.put("month", vBackLog.getMonth());
        dataMap.put("season", vBackLog.getSeason());
        dataMap.put("year", vBackLog.getYear());
        dataMap.put("remark", vBackLog.getRemark());
        dataMap.put("topUpAmount", vBackLog.getTopUpAmount());
        dataMap.put("backLevel", vBackLog.getBackLevel());
        dataMap.put("paymentTypeId", vBackLog.getPaymentTypeId());
        dataMap.put("rate", vBackLog.getRate());
        dataMap.put("totalMoney", vBackLog.getTopUpAmount());
        dataMap.put("expenseId", vBackLog.getExpenseId());
        dataMap.put("crDate", vBackLog.getCrDate());
        dataList.add(dataMap);
    }
    System.out.println("返佣日志列表111111111111111111111111111111"+dataList);
    ExcelDownloadUtil.downloadUtil(response, "返佣日志列表", columnMap, dataList);
}

/**导出返佣日志明细信息*/
@Override
public void exportRebateLogDetail(VBackLog record,HttpServletResponse response){
    LinkedHashMap<String, String> columnMap = new LinkedHashMap<>();
    columnMap.put("id", "ID");
    columnMap.put("waterNo", "批量操作号");
    columnMap.put("crmOrderNo", "相关CRM订单");
    columnMap.put("orderNo", "后台订单号");
    columnMap.put("customerName", "客户名称");
    columnMap.put("backType", "返佣类型");
    columnMap.put("month", "月季");
    columnMap.put("season", "季份");
    columnMap.put("year", "年份");
    columnMap.put("remark", "返佣说明");
    columnMap.put("orderAmount", "订单总金额");
    columnMap.put("returnUserName", "回款人");
    columnMap.put("backLevel", "本次返佣档位");
    columnMap.put("paymentTypeId", "用户结款类型");
    columnMap.put("backRate", "返佣比例");
    columnMap.put("backAmount", "本次返佣金额");
    columnMap.put("crDate", "创建时间");
    columnMap.put("BackLogOrderItemDetail", "返佣商品");
    List<Map<String, Object>> dataList = new ArrayList<>();

    //查出返佣日志
    List<VBackLog> byVBackLog = findByVBackLog(record);
    if(CollectionUtils.isEmpty(byVBackLog)){
        throw new NestedRuntimeException(ErrorCode.VBACKLOG_ERROR, "返佣日志查询结果为空，无法导出，请核对查询条件是否有效");
    }
    for(VBackLog vBackLog:byVBackLog){
        //查出返佣日志详情
        List<VBackLogOrderDetail> byWaterNo = findByWaterNo(vBackLog.getWaterNo());
        if(CollectionUtils.isEmpty(byWaterNo)){
            throw new NestedRuntimeException(ErrorCode.VBACKLOG_DETAIL_ERROR, "返佣日志详情查询结果为空，无法导出，请核对查询条件是否有效");
        }
        for(VBackLogOrderDetail vBackLogOrderDetail:byWaterNo){
            Map<String,Object> dataMap=new HashMap<>();
            dataMap.put("id", vBackLogOrderDetail.getId());
            dataMap.put("waterNo",vBackLogOrderDetail.getWaterNo() );
            dataMap.put("crmOrderNo",vBackLogOrderDetail.getCrmOrderNo());
            dataMap.put("orderNo",vBackLogOrderDetail.getOrderNo() );
            dataMap.put("customerName",vBackLogOrderDetail.getCustomerName() );
            dataMap.put("backType",vBackLogOrderDetail.getBackType() );
            dataMap.put("month",vBackLogOrderDetail.getMonth() );
            dataMap.put("season",vBackLogOrderDetail.getSeason() );
            dataMap.put("year",vBackLogOrderDetail.getYear() );
            dataMap.put("remark",vBackLogOrderDetail.getRemark() );
            dataMap.put("orderAmount",vBackLogOrderDetail.getOrderAmount());
            dataMap.put("returnUserName",vBackLogOrderDetail.getReturnUserName() );
            dataMap.put("backLevel",vBackLogOrderDetail.getBackLevel() );
            dataMap.put("paymentTypeId",vBackLogOrderDetail.getPaymentTypeId() );
            dataMap.put("backRate",vBackLogOrderDetail.getBackRate() );
            dataMap.put("backAmount",vBackLogOrderDetail.getBackAmount() );
            dataMap.put("crDate",vBackLogOrderDetail.getCrDate() );
            //获取返佣商品明细
            List<VBackLogOrderItemDetail> vBackLogOrderItemDetails = vBackLogOrderDetail.getvBackLogOrderItemDetail();
            if(CollectionUtils.isNotEmpty(vBackLogOrderItemDetails)){
                StringBuilder builder = new StringBuilder();
                for(VBackLogOrderItemDetail vBackLogOrderItemDetail : vBackLogOrderItemDetails){
                    builder.append(org.apache.commons.lang3.StringUtils.isNotBlank(vBackLogOrderItemDetail.getGoodsNo()) ? vBackLogOrderItemDetail.getGoodsNo()+"," : org.apache.commons.lang3.StringUtils.EMPTY);
                    builder.append(org.apache.commons.lang3.StringUtils.isNotBlank(vBackLogOrderItemDetail.getGoodsName()) ? vBackLogOrderItemDetail.getGoodsName()+"," : org.apache.commons.lang3.StringUtils.EMPTY);
                    builder.append(Objects.nonNull(vBackLogOrderItemDetail.getBackAmount()) ? vBackLogOrderItemDetail.getBackAmount().toString()+"," : org.apache.commons.lang3.StringUtils.EMPTY);
                    builder.append("\n");
                }
                dataMap.put("BackLogOrderItemDetail", builder.toString());
            }else{
                dataMap.put("BackLogOrderItemDetail", org.apache.commons.lang3.StringUtils.EMPTY);
            }
            dataList.add(dataMap);
        }
    }


    System.out.println("返佣日志明细列表111111111111111111111111111111"+dataList);
    ExcelDownloadUtil.downloadUtil(response, "返佣日志明细列表", columnMap, dataList);
}

/**导出商品返佣明细*/
@Override
public void exportRebateLogOrderDetail(VBackLog record,HttpServletResponse response){
    LinkedHashMap<String, String> columnMap = new LinkedHashMap<>();
    columnMap.put("id", "ID");
    columnMap.put("waterNo", "批量操作号");
    columnMap.put("customerName", "客户名称");
    columnMap.put("orderNo", "后台订单号");
    columnMap.put("crmOrderNo", "相关CRM订单");
    columnMap.put("backType", "返佣类型");
    columnMap.put("season", "季份");
    columnMap.put("remark", "返佣说明");
    columnMap.put("goodsNo", "商品编号");
    columnMap.put("goodsName", "商品名称");
    columnMap.put("basePrice", "基础单价");
    columnMap.put("quantity", "数量");
    columnMap.put("paidPrice", "售卖单价");
    columnMap.put("paidTotalPrice", "商品售卖总计");
    columnMap.put("cashPaidAmount", "现金账户支付部分");
    columnMap.put("canBack", "参与返佣");
    columnMap.put("backAmount", "本次返佣金额");
    columnMap.put("crDate", "创建时间");
    List<Map<String, Object>> dataList = new ArrayList<>();

    //查出返佣日志
    List<VBackLog> byVBackLog = findByVBackLog(record);
    if(CollectionUtils.isEmpty(byVBackLog)){
        throw new NestedRuntimeException(ErrorCode.VBACKLOG_ERROR, "返佣日志查询结果为空，无法导出，请核对查询条件是否有效");
    }
    for(VBackLog vBackLog:byVBackLog){
        //查出返佣日志详情
        List<VBackLogOrderDetail> byWaterNo = findByWaterNo(vBackLog.getWaterNo());
        if(CollectionUtils.isEmpty(byWaterNo)){
            throw new NestedRuntimeException(ErrorCode.VBACKLOG_DETAIL_ERROR, "返佣日志详情查询结果为空，无法导出，请核对查询条件是否有效");
        }
        for(VBackLogOrderDetail vBackLogOrderDetail:byWaterNo){
            //查询返佣商品明细
            List<VBackLogOrderItemDetail> vBackLogOrderItemDetails=findByOrderId(vBackLogOrderDetail.getOrderId());
            if(CollectionUtils.isEmpty(vBackLogOrderItemDetails)){
                throw new NestedRuntimeException(ErrorCode.VBACKLOG_ORDER_ERROR, "返佣商品查询结果为空，无法导出，请核对查询条件是否有效");
            }
            for(VBackLogOrderItemDetail vBackLogOrderItemDetail : vBackLogOrderItemDetails){
                Map<String,Object> dataMap=new HashMap<>();
                dataMap.put("id",vBackLogOrderDetail.getId());
                dataMap.put("waterNo",vBackLogOrderDetail.getWaterNo() );
                dataMap.put("customerName",vBackLogOrderDetail.getCustomerName() );
                dataMap.put("orderNo",vBackLogOrderDetail.getOrderNo() );
                dataMap.put("crmOrderNo",vBackLogOrderDetail.getCrmOrderNo());
                dataMap.put("backType", vBackLogOrderDetail.getBackType());
                dataMap.put("season", vBackLogOrderDetail.getSeason());
                dataMap.put("remark", vBackLogOrderDetail.getRemark());
                dataMap.put("goodsNo", vBackLogOrderItemDetail.getGoodsNo());
                dataMap.put("goodsName",vBackLogOrderItemDetail.getGoodsName());
                dataMap.put("basePrice", vBackLogOrderItemDetail.getBasePrice());
                dataMap.put("quantity", vBackLogOrderItemDetail.getQuantity());
                dataMap.put("paidPrice", vBackLogOrderItemDetail.getPaidPrice());
                dataMap.put("paidTotalPrice", vBackLogOrderItemDetail.getPaidTotalPrice());
                dataMap.put("cashPaidAmount", vBackLogOrderItemDetail.getCashPaidAmount());
                dataMap.put("canBack", vBackLogOrderItemDetail.getCanBack());
                dataMap.put("backAmount", vBackLogOrderItemDetail.getBackAmount());
                dataMap.put("crDate", vBackLogOrderItemDetail.getCrDate());
                dataList.add(dataMap);
            }
        }
    }
    System.out.println("商品返佣列表111111111111111111111111111111"+dataList);
    ExcelDownloadUtil.downloadUtil(response, "商品返佣列表", columnMap, dataList);
}

ExcelDownloadUtil.downloadUtil(response, "返佣日志列表", columnMap, dataList);

columnMap是导出的头上的第一行名字。
dataList是查出的数据。

转载于:https://www.cnblogs.com/thcy1314/p/10696526.html

weixin_30296405
关注
spring boot导出excel
06-28
spring boot导出excel，此处只是主要java代码，可参考文章：http://blog.csdn.net/wang124454731/article/details/73850645
springboot实现Excel文件导入与导出功能
12-19
springboot实现Excel文件导入与导出功能, 本次任务主要实现两个功能，一是如何将Excel文件导入后台服务器，解析文件中的内容，并且存入数据库中。二是如何将后台数据库中的数据导出为Excel表格。经过调研，实现此功能常使用的是POI技术。代码是在以前的项目上修改的，注释掉的内容请忽略。
springboot导出excel文件
最新发布
qq_65130017的博客
05-22 2583
用于操纵excel表格。
springboot实现将数据库中数据导出Excel
04-12
springboot实现将数据库中数据导出Excel。基于springboot加mybatis。简单通俗易懂！
Springboot+Poi实现Excel的导入导出
10-22
主要是springboot+myBatis+poi+mysql的使用，从数据库查询到结果集导出excel到本地，从本地中的excel文件导入到数据库中。
使用Springboot实现excel的导入导出
04-02
导出Excel 准备数据: 首先，你需要有一份员工数据，可以是从数据库中查询得到的，也可以是已有的数据集合。 创建Excel文件: 使用POI库创建一个新的Excel文件。在文件中创建一个工作表，并在第一行创建标题行，包含...
SpringBoot整合POI导出通用Excel的方法示例
08-24
本文主要介绍了 SpringBoot 整合 POI 导出通用 Excel 的方法示例，该方法可以帮助开发者快速实现 Excel 的导出功能。该示例代码详细地介绍了 SpringBoot 整合 POI 导出通用 Excel 的方法，包括准备工作、自定义注解...
Springboot POI导出Excel（浏览器）
08-19
Springboot POI导出Excel（浏览器） 本文主要介绍了如何使用 Springboot 和 POI 库来导出 Excel 文件，并提供了详细的示例代码。同时，还介绍了如何使用多线程来加快导出速度。 知识点一：Springboot 和 POI 库的...
springboot 导出excel 导入excel 生成excel 内容有点多
03-27
要导出Excel文件，首先需要引入支持Excel处理的库，如Apache POI或OpenCSV。Apache POI是Java中广泛使用的处理Microsoft Office文件的库，包括Excel。以下是一个简单的例子： ```java import org.apache.poi.ss....
《springboot中实现excel表格导出》
weixin_52236586的博客
03-16 7085
需要注意的是，无论使用哪种方法，都需要将Excel文档写入HTTP响应中，并设置正确的Content-Type和Content-Disposition头信息，以确保浏览器能够正确地识别Excel文档并下载它。
springboot导出excel
04-04
使用springboot开发，将excel功能嵌入到里面，在线导出excel
Springboot使用POI实现导出Excel文件示例
08-31
本篇文章主要介绍了Springboot使用POI实现导出Excel文件示例，非常具有实用价值，需要的朋友可以参考下。
SpringBoot导出Excel
dwhhome的博客
07-31 243
刚好有需求，封装了下较为通用的导出工具类 代码实现 import org.apache.poi.hssf.usermodel.*; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.CellType; import org.apache.poi.ss.usermodel.Row; import javax.servlet.http.HttpServletResponse; import java.io.I
在 SpringBoot 应用程序中实现 Excel 导出功能
Itmastergo的博客
02-01 1417
在导出 Excel 文件之前，需要定义数据模型，即将要导出的数据的结构。在这个例子中，定义一个简单的 Student 类作为数据模型。// 省略构造函数、getter 和 setter 方法。
SpringBoot实现数据excel导出
qq_37148705的博客
06-30 543
本案例将演示基于springboot或者ssm等框架数据导出为excel文件的操作，简单快捷易上手，在实际项目开发中粘贴即可使用。 一、准备环境 <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.17</version> </dependency> <depen
SpringBoot导出Excel的四种方式
02-01 8406
第三种方案是通过excel模板来实现的方法，现在基本已经废弃了，之所以放在这里是为了做一个参照，让大家看看不同的实现方法的区别。这种方式通过创建一个Excel模板和对应模板的实体类来实现文件导出，优点是实体类里不需要加注解了，而且在excel里可以设计一些style和格式，缺点是配置excelTemplate太麻烦了。该方法的优点：不用excel模板，导出导出方便。本人力荐前两种方法，有大量的项目使用，相关的博客也比较多，尤其是easyexcel，官方对每种导入导出的方式都有完整的案例参考，简单上手！
SpringBoot实现数据导出
Tenton的博客
02-08 2016
HTML5 代码： <a th:class="${active == '/uploadExcel.html'?'nav-link active':'nav-link'}" th:href="@{/admin/exportData}">导出学生信息</a> service实现类代码 @Override public XSSFWorkbook exportData(HttpServletResponse response) { List<Student&g
springboot实现导出excel的代码
07-27
在Spring Boot中实现导出Excel的功能可以使用Apache POI库。以下是一个简单的例子，展示了如何使用Spring Boot和Apache POI来导出Excel文件： ```java import org.apache.poi.ss.usermodel.*; import org.apache....
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值