HSSFWorkbook wb = new HSSFWorkbook();html
HSSFSheet sheet = wb.createSheet();字体
HSSFCellStyle setBorder = wb.createCellStyle();spa
1、设置背景色:htm
setBorder.setFillForegroundColor((short) 13);// 设置背景色
setBorder.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);it
2、设置边框:io
setBorder.setBorderBottom(HSSFCellStyle.BORDER_THIN); //下边框
setBorder.setBorderLeft(HSSFCellStyle.BORDER_THIN);//左边框
setBorder.setBorderTop(HSSFCellStyle.BORDER_THIN);//上边框
setBorder.setBorderRight(HSSFCellStyle.BORDER_THIN);//右边框class
3、设置居中:方法
setBorder.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 居中di
4、设置字体:view
HSSFFont font = wb.createFont();
font.setFontName("黑体");
font.setFontHeightInPoints((short) 16);//设置字体大小
HSSFFont font2 = wb.createFont();
font2.setFontName("仿宋_GB2312");