easyexcel 导出百万数据 +自定义样式。

Easyexcel 使用。

首先改写阿里开源如此强大，以下内容仅供参考，如有问题请指正。

pom 配置

<dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
     <!--阿里easyeacel-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>1.1.2-beta5</version>
        </dependency>
          <!--Swagger2配置-->
        <dependency>
            <groupId>io.springfox</groupId>
            <artifactId>springfox-swagger2</artifactId>
            <version>2.9.2</version>
        </dependency>
        <dependency>
            <groupId>io.springfox</groupId>
            <artifactId>springfox-swagger-ui</artifactId>
            <version>2.9.2</version>
        </dependency>
    </dependencies>

启动类

package com;

import lombok.extern.slf4j.Slf4j;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import springfox.documentation.swagger2.annotations.EnableSwagger2;

@EnableSwagger2
@SpringBootApplication
@Slf4j
public class SpringbootDemo {
    public static void main(String[] args) {

        SpringApplication.run(SpringbootDemo.class, args);
        log.info("9090启动类正常启动");
    }

}

Controller

@RestController
@Slf4j
@CellStyle(fontStyle = @FontStyle(color = IndexedColors.LIGHT_BLUE, size = 24))
public class TestController extends BaseRowModel {
    @RequestMapping("hahaha")
    @ResponseBody
    public String test01(HttpServletResponse response) throws IOException {
        System.out.println("fffffffs");
        //调用生成excel类
        String path = simpleWrite();
        //调用浏览器下载
        Down