Excel导出样式

最新推荐文章于 2024-07-10 03:40:33 发布

sandm1124

最新推荐文章于 2024-07-10 03:40:33 发布

阅读量133

点赞数

文章标签： excel

本文链接：https://blog.csdn.net/tianlovemi/article/details/133016701

版权

public class ProjectInfoExportStyle extends ExcelExportStylerDefaultImpl {

    public ProjectInfoExportStyle(Workbook workbook) {
        super(workbook);
    }

//    @Override
//    public CellStyle getHeaderStyle(short color) {
//        CellStyle titleStyle = this.workbook.createCellStyle();
//        Sheet sheet = this.workbook.getSheetAt(0);
//        sheet.getRow(0).setHeightInPoints(30);
//        Font font = this.workbook.createFont();
//        font.setColor(IndexedColors.BLACK.getIndex());
//        //字体
//        font.setFontName("Arial");
//        //设置字体大小
//        font.setFontHeightInPoints((short) 16);
//        font.setBold(true);
//        titleStyle.setFont(font);
//        titleStyle.setAlignment(HorizontalAlignment.CENTER);
//        titleStyle.setVerticalAlignment(VerticalAlignment.CENTER);
//        titleStyle.setWrapText(true);
//        return titleStyle;
//    }


    @Override
    public CellStyle getTitleStyle(short color) {
        XSSFCellStyle titleStyle = (XSSFCellStyle )this.workbook.createCellStyle();
        Sheet sheet = this.workbook.getSheetAt(0);
        sheet.getRow(0).setHeightInPoints((float)12.75);
        Font  font = this.workbook.createFont();
        //颜色
        font.setColor(IndexedColors.WHITE.getIndex());
        //字体
        font.setFontName("Arial");
        //设置字体大小
        font.setFontHeightInPoints((short) 10);
        //是否加粗字体
        font.setBold(true);
        titleStyle.setFont(font);
        // 设置背景色
        titleStyle.setFillForegroundColor(new XSSFColor(new java.awt.Color(128, 128, 128)));
        // 填充模式
        titleStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
        titleStyle.setAlignment(HorizontalAlignment.CENTER);
        titleStyle.setVerticalAlignment(VerticalAlignment.CENTER);
        titleStyle.setWrapText(true);
        // 单元格边框样式包含框线样式和边框颜色，可以对单元格的四边设置不同的样式
        titleStyle.setBorderTop(BorderStyle.THIN);
        titleStyle.setTopBorderColor(IndexedColors.BLACK.getIndex());
        titleStyle.setBorderBottom(BorderStyle.THIN);
        titleStyle.setBottomBorderColor(IndexedColors.BLACK.getIndex());
        titleStyle.setBorderLeft(BorderStyle.THIN);
        titleStyle.setLeftBorderColor(IndexedColors.BLACK.getIndex());
        titleStyle.setBorderRight(BorderStyle.THIN);
        titleStyle.setRightBorderColor(IndexedColors.BLACK.getIndex());
        return titleStyle;
    }

}