java写xls文件

梦里啥都有吖丶

已于 2022-08-26 14:33:18 修改

阅读量320

点赞数

分类专栏：笔记文章标签： java 开发语言后端

于 2021-12-10 10:42:55 首次发布

本文链接：https://blog.csdn.net/N0t_F0und_404/article/details/121850960

版权

笔记专栏收录该内容

12 篇文章 0 订阅

订阅专栏

 /**
     * 写.xls文件
     * @param FilePath  生成文件的全路径（路径+文件名）
     * @param headers  文件头假设为（String[] headers = {"A", "B", "C "};）
     * @return   成功 失败
     */
    public boolean writeAbcXlsFile(String FilePath,String [] headers,List<outVo> list) {
        HSSFWorkbook workbook = new HSSFWorkbook();
        FileOutputStream outputStream = null;
        try {
            File file = new File(FilePath);
            if (!file.exists()) {
                file.createNewFile();
            }
            outputStream = new FileOutputStream(file);
            HSSFSheet sheet = workbook.createSheet("sheet1名称");
            int rowNum = 1;
            HSSFRow row = sheet.createRow(0);
            for (int i = 0; i < headers.length; i++) {
                HSSFCell cell = row.createCell(i);
                HSSFRichTextString text = new HSSFRichTextString(headers[i]);
                cell.setCellValue(text);
            }
            for (outVo vo : list) {
                    HSSFRow row1 = sheet.createRow(rowNum);
                    row1.createCell(0).setCellValue(vo.getA());
                    row1.createCell(1).setCellValue(vo.getB());
                    row1.createCell(2).setCellValue(vo.getC());
                rowNum++;
            }
            workbook.write(outputStream);
        } catch (Exception e) {
            log.error("生成失败:{}", e);
            return false;
        } finally {
            try {
                if (workbook != null) {
                    workbook.close();
                }
                if (outputStream != null) {
                    outputStream.close();
                }
            } catch (Exception e) {
                log.error("生成失败:{}", e);
                return false;
            }
        }
        return true;
    }