springboot导出excel

最新推荐文章于 2024-08-14 09:40:46 发布

玉米絮絮

最新推荐文章于 2024-08-14 09:40:46 发布

阅读量87

点赞数

文章标签： java

本文链接：https://blog.csdn.net/yumixuxu/article/details/118930616

版权

后端专栏收录该内容

1 篇文章 0 订阅

订阅专栏

本文介绍了如何在Spring Boot项目中使用Easypoi库进行Excel数据的导入和导出，包括依赖引入、注解使用和实际操作示例。重点展示了`@Excel`注解在数据模型中的应用以及ExcelExportUtil和ExcelImportUtil的运用。

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

记录一下

    <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>

1.导入实现类


import cn.afterturn.easypoi.excel.annotation.Excel;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
@Builder
public class exportFile implements java.io.Serializable{

    //导入
    @Excel(name = "表头1")
    String str1;
	
	...
	
}

2.导出实现类

import cn.afterturn.easypoi.excel.annotation.Excel;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
@Builder
public class importFile implements java.io.Serializable {

    //导出
    @Excel(name = "表头1")
    String str1;
    
	...
	
}

3.实现


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 org.apache.poi.ss.usermodel.Workbook;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import java.io.File;
import java.io.FileOutputStream;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
import java.util.ArrayList;
import java.util.List;


@RunWith(SpringJUnit4ClassRunner.class)
@SpringBootTest
public class exportExcel {




    @Test
    public void test() {

        List<exportFile> listneirong = new ArrayList<>();
        ImportParams params = new ImportParams();
        params.setHeadRows(1);
        List<importFile> list = ExcelImportUtil.importExcel(
                new File("C:\\Users\\Administrator\\Desktop\\Book1 - 副本.xlsx"),//导入的文件
                importFile.class, params);
        list.stream().forEach(current -> {
            //业务逻辑
            //System.out.println(current.getStr1());
            exportFile nei = new exportFile();
            nei.setStr1(current.getStr1());
            listneirong.add(nei);

        });

        LocalDateTime now = LocalDateTime.now();
        DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("yyyyMMddhhmmss");
        String nowStr = dateTimeFormatter.format(now);
        try {
            Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(),
                    exportFile.class, listneirong);
            FileOutputStream fos = new FileOutputStream(nowStr.concat("-").concat("导出的文件.xlsx"));
            workbook.write(fos);
            fos.close();
        }catch (Exception e){
            e.printStackTrace();
        }

    }

}