poi 4 边框、对其方式设置

过时方法示例

          HSSFWorkbook wb = new HSSFWorkbook();
          HSSFSheet sheet = wb.createSheet("new   sheet");
          HSSFCellStyle style = wb.createCellStyle(); // 样式对象
          style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);// 垂直
          style.setAlignment(HSSFCellStyle.ALIGN_CENTER);// 水平
          
          //边框下
          style.setBorderBottom(HSSFCellStyle.BORDER_THIN);
          //边框左
          style.setBorderLeft(HSSFCellStyle.BORDER_THIN);
          //边框右
          style.setBorderRight(HSSFCellStyle.BORDER_THIN);
          //边框上
          style.setBorderTop(HSSFCellStyle.BORDER_THIN);

          //生成一个字体
          HSSFFont font=wb.createFont();
          font.setColor(HSSFColor.BLACK.index);//HSSFColor.VIOLET.index //字体颜色
          font.setFontHeightInPoints((short)12);
          font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);         //字体增粗
         //把字体应用到当前的样式
          style.setFont(font);
          
          HSSFRow row = sheet.createRow((short) 0);
          HSSFRow row2 = sheet.createRow((short) 1); 

新方法示例：

// 单元格格式
HSSFWorkbook excel= new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("new   sheet");
CellStyle cellStyle = excel.createCellStyle();
cellStyle.setRotation((short) 255);// 文字竖排列
cellStyle.setAlignment(HorizontalAlignment.CENTER);// 左右居中
cellStyle.setVerticalAlignment(VerticalAlignment.CENTER);// 上下居中
        
cellStyle.setBorderBottom(BorderStyle.THIN); //下边框
cellStyle.setBorderLeft(BorderStyle.THIN);//左边框
cellStyle.setBorderTop(BorderStyle.THIN);//上边框
cellStyle.setBorderRight(BorderStyle.THIN);//右边框
		
cellStyle.setWrapText(true);// 文字自动换行
cellStyle.setVerticalAlignment(VerticalAlignment.TOP);// 向上对齐
		
//字体
Font font = excel.createFont();
font.setColor(IndexedColors.BLUE.getIndex());
font.setFontName("宋体");
font.setBold(true);//加粗
cellStyle.setFont(font);