WritableCellFormat headerFormat = new WritableCellFormat(
HEADER_FONT_STYLE);
//水平居中對齊
headerFormat.setAlignment(Alignment.CENTRE);
//豎直方向居中對齊
headerFormat.setVerticalAlignment
(VerticalAlignment.CENTRE);
//建立標籤,參數依次為：列索引、行索引、內容、格式
Label seqLabel = new Label(0, 0, "序號", headerFormat);
//增加單元格
sheet.addCell(seqLabel);
//合併單元格,參數依次為：列索引、行索引、列索引 需要合併
的列的個數、行索引 需要合併的行的個數
sheet.mergeCells(0, 0, 0, 1);
//設置單元格寬度,以字元為單位
sheet.setColumnView(0, "序號".length() 10);
Label basicInfoLabel = new Label(1, 0, "基本信息",
headerFormat);
sheet.addCell(basicInfoLabel);
sheet.mergeCells(1, 0, 3, 0);//合併垮了3行.
sheet.mergeCells(1, 1, 1, 3);//合併垮了3列.
label = new Label(0, 1, "蘋果」);
sheet.mergeCells(0,1, 0, 3- 1);//合併垮了3列.
WritableCellFormat cellFormat = new WritableCellFormat();
cellFormat.setVerticalAlignment(VerticalAlignment.CENTRE);
// 垂直居中
label.setCellFormat(cellFormat);
sheet.addCell(label);
註：再次使cellFormat時,需要重新NEW WritableCellFormat .
[火星人
]
java 操作excel，jxl加邊框已經有536次圍觀
http://coctec.com/docs/java/show-post-60029.html
