jxl template 写excel
public static void main(String[] args) throws Exception {Workbook book1= Workbook.getWorkbook(new File("C:\\tmp\\Template.xls"));// TODO Auto-generated method stubWriteBOMExcel 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.BordercellFormat2.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("---------------------");}
页:
[1]