阿里巴巴Excel导出

最新推荐文章于 2025-04-28 16:54:54 发布

茶安安安

最新推荐文章于 2025-04-28 16:54:54 发布

阅读量707

点赞数

分类专栏：导出文章标签： excel java

本文链接：https://blog.youkuaiyun.com/weixin_47531979/article/details/121829767

版权

导出专栏收录该内容

1 篇文章

订阅专栏

本文介绍了如何使用阿里巴巴EasyExcel库在Spring MVC控制器中创建Excel导出功能，展示了TaskListDisplayExport实体类的定义，以及如何将数据转换为Excel文件并设置样式。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

阿里巴巴导出

依赖

<!--   阿里巴巴Excel工具     -->
	<dependency>
		<groupId>com.alibaba</groupId>
		<artifactId>easyexcel</artifactId>
		<version>2.2.6</version>
	</dependency>

实体类

@Data
@HeadRowHeight(40)
@HeadStyle(horizontalAlignment = HorizontalAlignment.CENTER, borderLeft = BorderStyle.THIN, borderRight = BorderStyle.THIN, borderBottom = BorderStyle.THIN, borderTop = BorderStyle.THIN, shrinkToFit = true)
@ContentStyle(dataFormat = 1, horizontalAlignment = HorizontalAlignment.CENTER, borderLeft = BorderStyle.THIN, borderRight = BorderStyle.THIN, borderBottom = BorderStyle.THIN, borderTop = BorderStyle.THIN, shrinkToFit = true)
@ApiModel(value = "TaskListDisplayExport", description = "任务书管理导出")
public class TaskListDisplayExport {
    /**
     * 飞行日期
     */
    @ApiModelProperty(value = "飞行日期")
    @ColumnWidth(value = 20)
    @ExcelProperty(value = "飞行日期", index = 0)
    private String flightDate;
    /**
     * 航班号
     */
    @ApiModelProperty(value = "航班号")
    @ColumnWidth(value = 20)
    @ExcelProperty(value = "航班号", index = 1)
    private String flightNo;
    }

Controller

  @ExportExcel(beanClass = TaskListDisplayExport.class)
    public void taskBookManagementAndExport(
            HttpServletResponse response,
            @RequestBody TaskListDisplayRequest request) {
        try (OutputStream out = response.getOutputStream()) {
            SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmm");
            String date = sdf.format(new Date());
            String fileName = "TaskBookExport" + date + ".xlsx";
            response.setCharacterEncoding("UTF-8");
            response.setHeader("content-Type", "application/vnd.ms-excel");
            response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8"));
            List<TaskListDisplayExport> alarmlist = missionStatementService.taskListDisplayExport(request);
            EasyExcelFactory.write(response.getOutputStream(), TaskListDisplayExport.class).sheet("模板").doWrite(alarmlist);
        } catch (IOException e) {
            try {
                throw new IOException(e.getMessage());
            } catch (IOException exception) {
                exception.printStackTrace();
            }

        }
    }