easyexcel 无模板写入_EasyExcel写文件

公共部分

HttpServletResponse

// 需要处理response

HttpServletResponse response;

response.reset();

response.setCharacterEncoding("UTF-8");

response.setContentType("application/x-download");

response.setHeader("Content-Disposition", "attachment; filename=" + new String(fileName.getBytes("UTF-8"), "GBK") + ".xlsx");

写入对象：SendTaskListDataBo

public class SendTaskListDataBo extends BaseRowModel implements Serializable {

/** value为表头，index为列号 */

@ExcelProperty(value = "发放主任务ID" ,index = 0)

private Long mainTaskId;

@ColumnWidth(20)// 列宽度

@ExcelProperty(value = "发放主任务名称" ,index = 1)

private String mainTaskName;

}

通过对象写入方式

// 需要写入的数据

List sendTaskListDataBos;

//