java µ¼³öÊý¾Ýµ½excel Ö® WritableWorkbook

ËùÐèjarÎļþΪ jxl.jar   ¿ÉÒÔÔÚ´Ë»ñÈ¡£º http://www.uushare.com/user/sudyguo/files/2209594
ÕâÖÖ·½·¨µ¼ÈëexcelЧÂʽϸߣ¬¿ÉÅúÁ¿µ¼³ö£» ¸ü¶à¸üÏêϸµÄÓ÷¨£¬¿ÉÒÔ¿´£º   http://pcedu.pconline.com.cn/empolder/gj/java/0608/853669_1.html
ʵÀý£º
´Ë¶Î´úÂëÓÃÓÚÉú³ÉexcelÎļþ
*/
WritableWorkbook book= Workbook.createWorkbook(new File(application.getRealPath("/")+"price.xls"));
//Éú³ÉÃûΪ"µÚÒ»Ò³"µÄ¹¤×÷±í£¬²ÎÊý0±íʾÕâÊǵÚÒ»Ò³
WritableSheet sheet=book.createSheet("µÚÒ»Ò³",0);
//ÔÚLabel¶ÔÏóµÄ¹¹Ôì×ÓÖÐÖ¸Ãûµ¥Ôª¸ñλÖÃÊǵÚÒ»ÁеÚÒ»ÐÐ(0,0)
WritableFont font1= new WritableFont(WritableFont.TIMES,14,WritableFont.BOLD);
WritableCellFormat format1=new WritableCellFormat(font1);
format1.setAlignment(jxl.format.Alignment.CENTRE);//ÉèÖÃΪ¾ÓÖÐ
sheet.setColumnView(1,20);//ÉèÖõÚ1Áпí¶È£¬6cm×óÓÒ
sheet.mergeCells(0,0,7,0);
Label label=new Label(0,0,"ͳ¼Æ±¨±í",format1);

//½«¶¨ÒåºÃµÄµ¥Ôª¸ñÌí¼Óµ½¹¤×÷±íÖÐ
sheet.addCell(label);
//½«¶¨ÒåºÃµÄµ¥Ôª¸ñÌí¼Óµ½¹¤×÷±íÖÐ
WritableFont font2=new WritableFont(WritableFont.createFont("¿¬Ìå_GB2312"),10,WritableFont.NO_BOLD );
WritableCellFormat format2=new WritableCellFormat(font2);
format2.setAlignment(jxl.format.Alignment.CENTRE);//ÉèÖÃΪ¾ÓÖÐ
//ÉèÖñ߿ò
format2.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.NONE);
label=new Label(0,2,"񅧏",format2);
sheet.addCell(label);
label=new Label(1,2,"²É¼¯ÈÕÆÚ",format2);
sheet.addCell(label);
label=new Label(2,2,"²É¼¯µã",format2);
sheet.addCell(label);
label=new Label(3,2,"Æ·ÖÖ",format2);
sheet.addCell(label);
label=new Label(4,2,"ÖÖÀà",format2);
sheet.addCell(label);
label=new Label(5,2,"Æ·ÖÖ˵Ã÷",format2);
sheet.addCell(label);
label=new Label(6,2,"×î¸ß¼Û",format2);
sheet.addCell(label);
label=new Label(7,2,"×îµÍ¼Û",format2);
sheet.addCell(label);
label=new Label(8,2,"ƽ¾ù¼Û",format2);
sheet.addCell(label);
label=new Label(9,2,"״̬",format2);
sheet.addCell(label);