??? HSSFWorkbook wb = new HSSFWorkbook();
??? //創(chuàng)建一個(gè)sheet及把sheet名字中文化
??? HSSFSheet sheet = wb.createSheet("TEST表格"); //建立新的sheet物件
??? wb.setSheetName(0, "TEST表格", (short)1);
??? //定義cell內(nèi)字體樣式
??? HSSFFont font = wb.createFont();
??? //設(shè)置字體色彩
??? font.setColor(HSSFFont.COLOR_RED);
??? font.setFontHeightInPoints( (short)24);
??? font.setFontName("宋體");
??? //創(chuàng)建一個(gè)樣式對(duì)象
??? HSSFCellStyle cellStyle = wb.createCellStyle();
??? cellStyle.setWrapText(true);
??? cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
??? cellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_BOTTOM);
??? cellStyle.setFont(font);
??? //創(chuàng)建新的row
??? HSSFRow row = sheet.createRow((short)0);
??? //創(chuàng)建新的cell
??? HSSFCell cell = row.createCell((short)3);
??? //把cell內(nèi)容中文化,這個(gè)一定要寫在setCellValue前面，不然的話，就還是會(huì)出現(xiàn)亂碼
??? cell.setEncoding((short)1);
??? cell.setCellValue("這是第一個(gè)生成的完整的EXCEL檔");
??? //把cell樣式增加進(jìn)來
??? cell.setCellStyle(cellStyle);
??? //把CELL合並起來
??? sheet.addMergedRegion(new Region(0, (short) 3, 2, (short)11));
//畫出新的行
??? HSSFRow rowA = sheet.createRow((short)3);
??? for(int i = 0; i < 10; i ++){
????? HSSFCell cellA = rowA.createCell( (short) i);
????? cellA.setEncoding( (short) 1);
????? cellA.setCellValue("POI+"+i);
??? }
//畫出新的列
for(int k = 4; k < 10; k++){
????? HSSFRow rowB = sheet.createRow((short)k);
????? for (int m = 0; m < 15; m++) {
??????? HSSFCell cells = rowB.createCell( (short) m);
??????? cells.setEncoding( (short) 1);
??????? cells.setCellValue("test"+k+m);
????? }
??? }