poi excel 单元格设置对角线

Q010_

于 2024-05-17 09:28:13 发布

阅读量146

点赞数 1

文章标签： excel

本文链接：https://blog.csdn.net/Q010_/article/details/138993041

版权

        HSSFClientAnchor hssfClientAnchor = new HSSFClientAnchor();
        hssfClientAnchor.setAnchor((short)0,0,0,0,(short)1,1,0,0);
        HSSFSimpleShape line = drawingPatriarch.createSimpleShape(hssfClientAnchor);
        line.setShapeType(HSSFSimpleShape.OBJECT_TYPE_LINE);
        line.setLineStyle(HSSFShape.LINESTYLE_SOLID);
        line.setLineWidth(3350);
        //设置上下左右居中保证字体在对角线两边
           firstCell.setCellValue("课程        学生");
        CellStyle firstCellStyle = workbook.createCellStyle();
        firstCellStyle.setVerticalAlignment(VerticalAlignment.CENTER); // 垂直居中对齐
        firstCellStyle.setAlignment(HorizontalAlignment.CENTER); // 水平居中对齐
        firstCell.setCellStyle(firstCellStyle);
        ```