public static void main(String[] args) throws Exception {
Workbook book1= Workbook.getWorkbook(new File("C:\\tmp\\Template.xls"));
// TODO Auto-generated method stub
WriteBOMExcel w = new WriteBOMExcel();
//w.writeExcel0();
WritableWorkbook book = Workbook.createWorkbook(new File("C:\\tmp\\aaa.xls"),book1);
WritableSheet sheet = book.getSheet(0);
sheet.insertColumn(2);
sheet.setColumnView(2,3);
WritableFont font= new WritableFont(WritableFont.createFont("新細明體"),10,WritableFont.NO_BOLD);
WritableCellFormat cellFormat2 = new WritableCellFormat(font);
cellFormat2.setBorder(Border.ALL, jxl.format.BorderLineStyle.THIN); //Border是jxl.format.Border
cellFormat2.setWrap(true);
cellFormat2.setAlignment(jxl.format.Alignment.CENTRE);
cellFormat2.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);
Label label = new Label(2,6,"test");
label.setCellFormat(cellFormat2);
sheet.addCell(label);
sheet.mergeCells(2,3,2,4);
Label labe2 = new Label(2,3,"5\r\t階");
labe2.setCellFormat(cellFormat2);
sheet.addCell(labe2);
Label A1 = (Label)sheet.getWritableCell(0,1);
A1.setCellFormat(cellFormat2);
//Label A2 = (Label)sheet.getWritableCell(15,2);
//A2.setCellFormat(cellFormat2);
//A2.setString("88888");
//sheet.addCell(A1);
Label labe3 = new Label(15,2,"60");
sheet.addCell(labe3);
//jxl.write.Number number = new jxl.write.Number(2,3,789.123);
//sheet.addCell(number);
book.write();
book.close();
System.out.println("---------------------");
}