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 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("---------------------");
	}

 

评论

1 楼 talin2010 2011-07-25  

!