easypoi导入导出

最新推荐文章于 2024-07-14 23:57:54 发布

qq_31594647

最新推荐文章于 2024-07-14 23:57:54 发布

阅读量182

点赞数

文章标签： easypoi

本文链接：https://blog.csdn.net/qq_31594647/article/details/100217844

版权

本文介绍了如何使用Easypoi库来处理Excel的导入导出功能，特别是针对一对多的数据结构，展示了如何在HTML页面上操作，并通过异步函数实现数据的动态处理。在实际应用中，例如一条保单可以关联多个被保人信息，这种一对多的关系在导出时会以合适的方式展示。

摘要由CSDN通过智能技术生成

<!-- 集成easypoi组件 http://easypoi.mydoc.io/ .start -->
<dependency>
    <groupId>cn.afterturn</groupId>
    <artifactId>easypoi-base</artifactId>
    <version>3.2.0</version>
</dependency>
<dependency>
    <groupId>cn.afterturn</groupId>
    <artifactId>easypoi-web</artifactId>
    <version>3.2.0</version>
</dependency>
<dependency>
    <groupId>cn.afterturn</groupId>
    <artifactId>easypoi-annotation</artifactId>
    <version>3.2.0</version>
</dependency>
<!-- 集成easypoi组件http://easypoi.mydoc.io/  .end -->

<!-- lombok可使代码更简洁 -->
<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
    <scope>provided</scope>
</dependency>

@Data //注解在类上, 为类提供读写属性, 此外还提供了 equals()、hashCode()、toString() 方法
@NoArgsConstructor //生成一个无参的构造函数
@AllArgsConstructor //生成一个有参构造函数 注意实体类中一定要有空构造函数
public class ExportPtRate {

    private static final long serialVersionUID = 1L;

    @Excel(name = "性别", orderNum = "0")
    private String gender;

    @Excel(name = "年龄", orderNum = "1")
    private String age;

    @Excel(name = "交费期", orderNum = "2")
    private String payendyearFactor;

    @Excel(name = "保障期", orderNum = "3")
    private String insuyearFactor;

    @Excel(name = "职业", orderNum = "4")
    private String occupation;

    @Excel(name = "有无社保", orderNum = "5")
    private String socialSec;

    @Excel(name = "保费", orderNum = "6")
    private String premium;

    
}

package com.ssish.saas.utils;

import cn.afterturn.easypoi.excel.ExcelExportUtil;
import cn.afterturn.easypoi.excel.ExcelImportUtil;
import cn.afterturn.easypoi.excel.entity.ExportParams;
import cn.afterturn.easypoi.excel.entity.ImportParams;
import cn.afterturn.easypoi.excel.entity.enmus.ExcelType;
import org.apache.commons.lang3.StringUtils;
import org.apache.poi.ss.usermodel.Workbook;
import org.springframework.web.multipart.MultipartFile;

import javax.servlet.http.HttpServletResponse;
import java.io.File;
import java.net.URLEncoder;
import java.util.List;
import java.util.Map;
import java.util.NoSuchElementException;

/**
 * @author 
 * @Description TODO
 * @date 2019/8/30 15:34
 */
public class EasyPoiUtils {


    public static void exportExcel(List<?> list, String title, String sheetName, Class<?> pojoClass,String fileName,boolean isCreateHeader, HttpServletResponse response) throws Exception {
        ExportParams exportParams = new ExportParams(title, sheetName);
        exportParams.setCreateHeadRows(isCreateHeader);
        defaultExport(list, pojoClass, fileName, response, exportParams);

    }
    public static void exportExcel(List<?> list, String title, String sheetName, Class<?> pojoClass,String fileName, HttpServletResponse response) throws Exception {
        defaultExport(l