java easyExcel简单的写

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.alibaba.excel.annotation.write.style.HeadFontStyle;
import lombok.Data;

@Data
@ContentRowHeight(15)
@HeadFontStyle(fontName = "微软雅黑", fontHeightInPoints = 11, bold = false)
public class CompanyExportDto {

    @ExcelProperty("公司编码")
    @ColumnWidth(20)
    private String companyCode;

    @ExcelProperty("公司名称")
    @ColumnWidth(40)
    private String companyName;

    @ExcelProperty("公司税号")
    @ColumnWidth(20)
    private String companyTaxNumber;

    @ExcelProperty("地址")
    @ColumnWidth(40)
    private String companyAddress;

    @ExcelProperty("电话")
    @ColumnWidth(20)
    private String companyNumber;

    @ExcelProperty("开户行")
    @ColumnWidth(30)
    private String openingBank;

    @ExcelProperty("账号")
    @ColumnWidth(30)
    private String account;

}

public void exportData(HttpServletResponse response, TRbstReimbursementDeptDto deptDto) {

        String fileName = "预算表";
        try {
            fileName = URLEncoder.encode(fileName, "UTF-8");
            response.setContentType("application/vnd.ms-excel;charset=utf-8");

            response.setHeader("Content-Disposition", "attachment;filename=" + fileName + ".xlsx");

            List<CompanyExportDto> list = new ArrayList<>();
            CompanyExportDto dto = new CompanyExportDto();


            list.add(dto);

            EasyExcel.write(response.getOutputStream(), CompanyExportDto.class)
                    .sheet()
                    .doWrite(list);

        } catch (IOException e) {
            e.printStackTrace();
        }

    }