导出个人简历EXCEL

最新推荐文章于 2021-02-27 09:40:25 发布

偷偷学习被我发现

最新推荐文章于 2021-02-27 09:40:25 发布

阅读量759

点赞数

分类专栏：又吃成长快乐了

本文链接：https://blog.csdn.net/qq_37432174/article/details/98475349

版权

本文介绍如何利用前端技术将个人简历数据转换并导出为EXCEL文件，详细阐述了整个过程和关键步骤。

摘要由CSDN通过智能技术生成

action:

package com.hrm.utils;

import java.io.IOException;
import java.io.OutputStream;
import java.net.URLDecoder;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.util.CellRangeAddress;

import com.hrm.pojo.Dossier;


public class ExportExcelUtil {
	 /**
     * 导出数据生成EXCEL方法
     * @param request
     * @param response
     * @param list
     * @throws IOException
     */
    public static void exportExcelBook(HttpServletRequest request, HttpServletResponse response,Dossier dossier)
            throws IOException {
        if (dossier == null) {
            return;
        }
        String fileName = URLDecoder.decode(request.getParameter("dossierNo"),"UTF-8");
        HSSFWorkbook workbook = new HSSFWorkbook();
        HSSFSheet sheet = workbook.createSheet();
        int columnSize = 8;
        for(int i = 0;i< columnSize;i++ ){
            sheet.setColumnWidth(i, 5000);
        }

        HSSFFont headfont = workbook.createFont();
        headfont.setFontName("宋体");
        headfont.setFontHeightInPoints((short) 22);
        headfont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
        HSSFCellStyle headstyle = workbook.createCellStyle();
        headstyle.setFont(headfont);
        headstyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        headstyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
        headstyle.setLocked(true);
        headstyle.setWrapText(true);
        headstyle.setBorderLeft((short) 1);
        headstyle.setLeftBorderColor(HSSFColor.BLACK.index);
        headstyle.setRightBorderColor(HSSFColor.BLACK.index);
        headstyle.setBorderRight((short) 1);
        HSSFFont columnHeadFont = workbook.createFont();
        columnHeadFont.setFontName("宋体");
        columnHeadFont.setFontHeightInPoints((short) 12);
        columnHeadFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);

        HSSFCellStyle columnHeadStyle = workbook.createCellStyle();
        columnHeadStyle.setFont(columnHeadFont);
        columnHeadStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        columnHeadStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
        columnHeadStyle.setLocked(true);
        columnHeadStyle.setWrapText(true);
        columnHeadStyle.setTopBorderColor(HSSFColor.BLACK.index);
        columnHeadStyle.setBorderTop((short) 1);
        columnHeadStyle.setLeftBorderColor(HSSFColor.BLACK.index);
        columnHeadStyle.setBorderLeft((short) 1);
        columnHeadStyle.setRightBorderColor(HSSFColor.BLACK.index);
        columnHeadStyle.setBorderRight((short) 1);
        columnHeadStyle.setBottomBorderColor(HSSFColor.BLACK.index);
        columnHeadStyle.setBorderBottom((short) 1);


        HSSFFont font = workbook.createFont();
        font.setFontName("宋体");
        font.setFontHeightInPoints((short) 12);
        HSSFCellStyle centerstyle = workbook.createCellStyle();
        centerstyle.setFont(font);
        centerstyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        centerstyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
        centerstyle.setWrapText(true);
        centerstyle.setLeftBorderColor(HSSFColor.BLACK.index);
        centerstyle.setBorderLeft((short) 1);
        centerstyle.setTopBorderColor(HSSFColor.BLACK.index);
        centerstyle.setBorderTop((short) 1);
        centerstyle.setRightBorderColor(HSSFColor.BLACK.index);