POI--再探

1. 设置单元格内容的位置
   

   public static void main(String[] args) throws Exception {
           Workbook wb = new HSSFWorkbook();
   
           Sheet sheet = wb.createSheet("options");
           Row row = sheet.createRow(2);
           row.setHeightInPoints(30);
   
           CreateCell(wb, row, 0, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_BOTTOM);
           CreateCell(wb, row, 1, CellStyle.ALIGN_CENTER_SELECTION, CellStyle.VERTICAL_BOTTOM);
           CreateCell(wb, row, 2, CellStyle.ALIGN_FILL, CellStyle.VERTICAL_CENTER);
           CreateCell(wb, row, 3, CellStyle.ALIGN_GENERAL, CellStyle.VERTICAL_CENTER);
           CreateCell(wb, row, 4, CellStyle.ALIGN_JUSTIFY, CellStyle.VERTICAL_JUSTIFY);
           CreateCell(wb, row, 5, CellStyle.ALIGN_LEFT, CellStyle.VERTICAL_TOP);
           CreateCell(wb, row, 6, CellStyle.ALIGN_RIGHT, CellStyle.VERTICAL_TOP);
   
           FileOutputStream fileOut = new FileOutputStream("e:/poi/demo7.xls");
           wb.write(fileOut);
           fileOut.close();
       }
   
       /**
        *  以某种方式创建Cell
        * @param wb         工作薄
        * @param row         行号
        * @param column    单元格列号
        * @param halign    水平位置
        * @param valign    垂直位置
        */
       private static void CreateCell(Workbook wb, Row row, int column, short halign, short valign){
           Cell cell = row.createCell(column);
           cell.setCellValue("Align It");
   
           CellStyle cellStyle = wb.createCellStyle();
           cellStyle.setAlignment(halign);
           cellStyle.setVerticalAlignment(valign);
           cell.setCellStyle(cellStyle);
       }

2. 设置单元格的边框
   

   Workbook wb = new HSSFWorkbook();
           Sheet sheet = wb.createSheet("borders");
   
           Row row = sheet.createRow(1);
   
           Cell cell = row.createCell(1);
           cell.setCellValue(4);
   
           CellStyle style = wb.createCellStyle();
           //设置下边框
           style.setBorderBottom(CellStyle.BORDER_THIN);
           style.setBottomBorderColor(IndexedColors.BLACK.getIndex());
           //设置左边框
           style.setBorderLeft(CellStyle.BORDER_THIN);
           style.setBottomBorderColor(IndexedColors.GREEN.getIndex());
           //设置右边框
           style.setBorderRight(CellStyle.BORDER_THIN);
           style.setBorderBottom(IndexedColors.BLUE.getIndex());
           //设置上边框
           style.setBorderTop(CellStyle.BORDER_MEDIUM_DASHED);
           style.setTopBorderColor(IndexedColors.BLACK.getIndex());
   
           cell.setCellStyle(style);
   
           FileOutputStream fileOut = new FileOutputStream("e:/poi/demo8.xls");
           wb.write(fileOut);
           fileOut.close();