POI导出EXCEL

最新推荐文章于 2024-11-05 21:45:22 发布

Blionbibor

最新推荐文章于 2024-11-05 21:45:22 发布

阅读量189

点赞数

分类专栏： poi-excel 文章标签： poi excel

本文链接：https://blog.csdn.net/Blionbibor/article/details/78605563

版权

poi-excel 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

前端点击a标签，a标签href设置为到处请求地址即可使用POI导出EXCEL
try{
HSSFWorkbook wb = new HSSFWorkbook();
//设置表头样式
HSSFCellStyle style = wb.createCellStyle();
style.setAlignment(HSSFCellStyle.ALIGN_CENTER);//居中格式
//字体样式
HSSFFont font = wb.createFont();
font.setFontName(“宋体”);
font.setFontHeightInPoints((short)12);
font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
style.setFont(font);
String dlData = getUsedExamineStyle();
String[] heads = {“考核人编号”,”考核人”,”被考核人编号”,”被考核人”,”考核类型” + dlData};

    HSSFSheet sheet = wb.createSheet("Sheet1");

    HSSFRow headRow = sheet.createRow(0);
    for(int i=0; i < heads.length; i++){
        HSSFCell cell = headRow.createCell((short)i);
        cell.setEncoding(HSSFCell.ENCODING_UTF_16);
        cell.setCellStyle(style);
        cell.setCellValue(heads[i]);
    }
    sheet.setColumnWidth((short)0, (short)5120);
    sheet.setColumnWidth((short)1, (short)6120);
    sheet.setColumnWidth((short)2, (short)5120);
    sheet.setColumnWidth((short)3, (short)6120);
    sheet.setColumnWidth((short)4, (short)15120);

    ByteArrayOutputStream baos = new ByteArrayOutputStream();
    wb.write(baos);
    byte[] bytes = baos.toByteArray();
    InputStream is = new ByteArrayInputStream(bytes);

    response.reset();
    response.setHeader("Content-Disposition", "attachment;filename="+new String("考核计划导入模板.xls".getBytes("UTF-8"), "ISO-8859-1"));  
    response.setContentType("application/x-download;charset=UTF-8");  
    response.setCharacterEncoding("UTF-8"); 

    OutputStream sos = response.getOutputStream();
    wb.write(sos);
    sos.close();
}catch(Exception ex){
    ex.printStackTrace();
}