PIO导出Excel 设置样式

简单方法代码

/**
     *
     * @param workbook  工作薄
     * @param horizontalAlignment  单元格水平对齐方式
     * @param fontSize  字体大小
     * @param bool 是否加粗
     * @param borderStyle 边框
     * @return
     */
    public static XSSFCellStyle style(Workbook workbook,HorizontalAlignment horizontalAlignment,int fontSize,boolean bool,BorderStyle borderStyle){
        //设置居中
        XSSFCellStyle xssfCellStyle = (XSSFCellStyle) workbook.createCellStyle();
        //水平居中
        xssfCellStyle.setAlignment(horizontalAlignment);
        //垂直居中
        xssfCellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
        Font font = workbook.createFont();
        // 字体大小
        font.setFontHeightInPoints((short) fontSize);
        //是否加粗
        font.setBold(bool);
        xssfCellStyle.setFont(font);
        xssfCellStyle.setWrapText(true);//设置自动换行
        // 边框
        xssfCellStyle.setBorderBottom(borderStyle);
        xssfCellStyle.setBorderRight(borderStyle);
        xssfCellStyle.setBorderTop(borderStyle);
        xssfCellStyle.setBorderLeft(borderStyle);

        xssfCellStyle.setBottomBorderColor(IndexedColors.BLACK.getIndex());
        xssfCellStyle.setRightBorderColor(IndexedColors.BLACK.getIndex());
        xssfCellStyle.setTopBorderColor(IndexedColors.BLACK.getIndex());
        xssfCellStyle.setLeftBorderColor(IndexedColors.BLACK.getIndex());
        return xssfCellStyle;
    }