Excel表格导出校验

excel表格导出工具类

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.write.builder.ExcelWriterSheetBuilder;
import java.io.IOException;
import java.net.URLEncoder;
import java.text.SimpleDateFormat;
import java.util.Collection;
import java.util.Date;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.assertj.core.util.Lists;
import org.springframework.util.CollectionUtils;

public class ExcelUtil {
    public ExcelUtil() {
    }
    
    public static void export(List records, Class recordClass, String fileName, String sheetName, HttpServletRequest request, HttpServletResponse response) throws IOException {
        if (CollectionUtils.isEmpty((Collection)records)) {
            records = Lists.newArrayList();
        }
        
        response.setContentType("application/x-download");
        response.setCharacterEncoding("utf-8");
        String newFileName = new String((fileName + (new SimpleDateFormat("yyyy-MM-dd")).format(new Date())).getBytes(), "UTF-8") + ".xlsx";
        response.addHeader("Content-Disposition", "attachment; filename=\"" + URLEncoder.encode(newFileName, "UTF-8") + "\"");
        EasyExcel.write(response.getOutputStream(), recordClass).sheet(sheetName).doWrite((List)records);
    }
    
    public static void export(List records, Class recordClass, String fileName, String sheetName, HttpServletRequest request, HttpServletResponse response, List<String> includeColumnFiledNames) throws IOException {
        if (CollectionUtils.isEmpty((Collection)records)) {
            records = Lists.newArrayList();
        }
        
        response.setContentType("application/x-download");
        response.setCharacterEncoding("utf-8");
        String newFileName = new String((fileName + (new SimpleDateFormat("yyyy-MM-dd")).format(new Date())).getBytes(), "UTF-8") + ".xlsx";
        response.addHeader("Content-Disposition", "attachment; filename=\"" + URLEncoder.encode(newFileName, "UTF-8") + "\"");
        ((ExcelWriterSheetBuilder)EasyExcel.write(response.getOutputStream(), recordClass).sheet(sheetName).includeColumnFiledNames(includeColumnFiledNames)).doWrite((List)records);
    }
}

控制层

@ApiOperation(value = "导出xxx", notes = "导出xxx")
    @PostMapping("/export")
    public void export(HttpServletResponse response, HttpServletRequest request
            , @ApiParam(value = "查询条件") @RequestBody(required = false) xxx query) throws IOException {
        // 原有列表查询
        WebPage<xxx> result = service.pageInfo(query);
        List<xxx> records = result.getResults();
        List<xxx> list = new ArrayList<>();
        records.forEach(do -> {
            // 原对象数据copy到导出excel对象
            xxxExcel ex = new xxxExcel();
            BeanUtils.copyProperties(do, ex);
            list.add(ex);
        });

        ExcelUtil.export(list, xxxExcel.class, "文件名", "文件名", request, response);
    }