ObjectExcelView，EXCEL导出工具类，适用于POI-3.17

最新推荐文章于 2021-07-01 00:00:24 发布

vitaair

最新推荐文章于 2021-07-01 00:00:24 发布

阅读量552

点赞数

CC 4.0 BY-SA版权

分类专栏： springboot

本文链接：https://blog.csdn.net/vitaair/article/details/109981705

springboot 专栏收录该内容

8 篇文章

订阅专栏

本文介绍了一个基于Spring MVC的自定义视图组件，用于将数据导出为Excel文件。该组件利用Apache POI库创建XLSX文件，并支持通过HTTP响应下载。文章详细展示了如何配置样式、设置单元格内容及标题等。

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

import org.apache.commons.lang3.StringUtils;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.streaming.SXSSFCell;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.web.servlet.view.document.AbstractXlsxStreamingView;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.Calendar;
import java.util.List;
import java.util.Map;

/**
 * 导出Excel窗口
 */
public class ObjectExcelView extends AbstractXlsxStreamingView {

    @Override
    protected void buildExcelDocument(Map<String, Object> model,
                                      Workbook workbook,
                                      HttpServletRequest request,
                                      HttpServletResponse response) throws Exception {

        String fileName = (String) model.get("fileName");
        String sheetName = (String) model.get("sheetName");
        List<String> titles = (List<String>) model.get("titles");
        List<Map<String, String>> varList = (List<Map<String, String>>) model.get("varList");
        if (StringUtils.isBlank(fileName)) {
            fileName = DateUtils.getDate("yyyyMMddHHmmss");
        }
        if (StringUtils.isBlank(sheetName)) {
            sheetName = "sheet1";
        }
        response.setContentType("application/octet-stream");
        response.setHeader("Content-Disposition", "attachment;filename=" + fileName + ".xls");

        Sheet sheet;
        Row row;
        Cell cell;
        SXSSFWorkbook sxssfWB = (SXSSFWorkbook) workbook;
        sheet = sxssfWB.createSheet(sheetName);


        /**
         * 设置样式
         */
        CellStyle headerStyle = sxssfWB.createCellStyle();
        //居中
        headerStyle.setAlignment(HorizontalAlignment.CENTER);
        //垂直
        headerStyle.setVerticalAlignment(VerticalAlignment.CENTER);
        //标题字体
        Font headerFont = sxssfWB.createFont();
        //字体加粗
        headerFont.setBold(true);
        headerFont.setFontHeightInPoints((short) 11);
        headerStyle.setFont(headerFont);
        short width = 20, height = 25 * 20;
        sheet.setDefaultColumnWidth(width);

        int iniRow = 0;
        row = sheet.createRow((short) iniRow);
        /**
         * 设置表格标题行
         */
        for (int i = 0; i < titles.size(); i++) {
            cell = row.createCell(i);
            cell.setCellType(SXSSFCell.CELL_TYPE_STRING);
            cell.setCellValue(titles.get(i));
            cell.setCellStyle(headerStyle);
        }

        sheet.getRow(0).setHeight(height);
        //内容样式
        CellStyle contentStyle = sxssfWB.createCellStyle();
        //居中
        headerStyle.setAlignment(HorizontalAlignment.CENTER);

        int varCount = varList.size();

        /**
         * 设置表格内容
         */
        for (int i = 0; i < varCount; i++) {
            row = sheet.createRow(i + 1);
            Map<String, String> vpd = varList.get(i);
            for (int j = 0; j < titles.size(); j++) {
                cell = row.createCell(j);
                String varstr = vpd.get("var" + (j + 1)) != null ? vpd.get("var" + (j + 1)) : "";
                cell.setCellType(SXSSFCell.CELL_TYPE_STRING);
                cell.setCellValue(varstr);
                cell.setCellStyle(contentStyle);
            }
        }
    }

}