javaÖÐjxlµ¼³öÊý¾Ýµ½excelµÄÀý×Ó
¹Ø¼ü×Ö: javaÖÐjxlµ¼³öÊý¾Ýµ½excelµÄÀý×Ó
ÒªÍùxlsÎļþÀïÃæÐ´ÈëÊý¾ÝµÄʱºòÐèҪעÒâµÄÊǵÚһҪн¨Ò»¸öxlsÎļþ
OutputStream os=new FileOutputStream("c:\\excel2.xls" );
ÔÙ½¨ÍêÕâ¸öÎļþµÄʱºòÔÙ½¨Á¢¹¤×÷Îļþ
jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(new File(os));
Èç¹ûÕâ¸öÎļþÒѾ´æÔÚ,ÄÇôÎÒÃÇ¿ÉÒÔÔÚÕâ¸öÎļþÀïÃæ¼ÓÈëÒ»¸ösheetΪÁ˺ÍÒÔǰµÄÊý¾Ý½øÐзֿª;
jxl.write.WritableSheet ws = wwb.createSheet("Test Sheet 1" , 0);
ÔÚcreateSheet·½·¨ÀïÇ°ÃæµÄ²ÎÊýÊÇsheetÃû£¬ºóÃæÊÇÒª²Ù×÷µÄsheetºÅ
½ÓÏÂÀ´¾Í¿ÉÒÔÍùÕâ¸öÎļþÀïÃæÐ´ÈëÊý¾ÝÁË
дÈëÊý¾ÝµÄʱºò×¢ÒâµÄ¸ñʽ
£¨1£©Ìí¼ÓµÄ×ÖÌåÑùʽ
jxl.write.WritableFont wf = new jxl.write.WritableFont(WritableFont.TIMES, 18, WritableFont.BOLD, true);
WritableFont()·½·¨Àï²ÎÊý˵Ã÷£º
Õâ¸ö·½·¨ËãÊÇÒ»¸öÈÝÆ÷£¬¿ÉÒԷŽøÈ¥ºÃ¶àÊôÐÔ
µÚÒ»¸ö: TIMESÊÇ×ÖÌå´óС£¬ËûдµÄÊÇ18
µÚ¶þ¸ö: BOLDÊÇÅжÏÊÇ·ñΪбÌå,Ñ¡ÔñtrueʱΪбÌå
µÚÈý¸ö: ARIAL
µÚËĸö: UnderlineStyle.NO_UNDERLINE Ï»®Ïß
µÚÎå¸ö: jxl.format.Colour.RED ×ÖÌåÑÕÉ«ÊǺìÉ«µÄ
jxl.write.WritableCellFormat wcfF = new jxl.write.WritableCellFormat(wf);
jxl.write.Label labelC = new jxl.write.Label(0, 0, "This is a Label cell" £¬wcfF);
ws.addCell(labelC);
ÔÚLabel()·½·¨ÀïÃæÓÐÈý¸ö²ÎÊý
µÚÒ»¸öÊÇ´ú±íÁÐÊý,
µÚ¶þÊÇ´ú±íÐÐÊý£¬
µÚÈý¸ö´ú±íҪдÈëµÄÄÚÈÝ
µÚËĸöÊÇ¿ÉÑ¡ÏÊÇÊäÈëÕâ¸ölabelÀïÃæµÄÑùʽ
È»ºóͨ¹ýдsheetµÄ·½·¨addCell£¨£©°ÑÄÚÈÝд½øsheetÀïÃæ¡£
£¨2£©Ìí¼Ó´øÓÐformattingµÄNumber¶ÔÏó
jxl.write.NumberFormat nf = new jxl.write.NumberFormat("#.##" );
£¨3£©Ìí¼ÓNumber¶ÔÏó
£¨3.1£©ÏÔʾnumber¶ÔÏóÊý¾ÝµÄ¸ñʽ
jxl.write.NumberFormat nf = new jxl.write.NumberFormat("#.##" );
jxl.write.WritableCellFormat wcfN = new jxl.write.WritableCellFormat(nf);
jxl.write.Number labelNF = new jxl.write.Number(1, 1, 3.1415926, wcfN);
ws.addCell(labelNF);
Number()·½·¨²ÎÊý˵Ã÷:
ǰÁ½ÉϱíʾÊäÈëµÄλÖÃ
µÚÈý¸ö±íʾÊäÈëµÄÄÚÈÝ
£¨4£©Ìí¼ÓBoolean¶ÔÏó
jxl.write.Boolean labelB = new jxl.write.Boolean(0, 2, false);
ws.addCell(labelB);
£¨5£©Ìí¼ÓDateTime¶ÔÏó
jxl.write.DateTime labelDT = new jxl.write.DateTime(0,
Ïà¹ØÎĵµ£º
DOMÊÇ»ùÓÚÆ½Ì¨¡¢ÓïÑÔÎ޹صĹٷ½W3C±ê×¼¡£»ùÓÚÊ÷µÄ²ã´Î£¬ÆäÓŵãÊÇ¿ÉÒÔÒÆÖ²£¬±à³ÌÈÝÒ×£¬¿ª·¢ÈËÔ±Ö»ÐèÒªµ÷Óý¨Ê÷µÄÖ¸Áî¡£ÆäȱµãÊǼÓÔØ´óÎļþ²»ÀíÏë¡£
¡¡¡¡SAXÊÇ»ùÓÚʼþÄ£Ð͵ģ¬ËüÔÚ½âÎö XML ÎĵµµÄʱºò¿ÉÒÔ´¥·¢Ò»ÏµÁеÄʼþ£¬µ±·¢ÏÖ¸ø¶¨µÄtagµÄʱºò£¬Ëü¿ÉÒÔ¼¤»îÒ»¸ö»Øµ÷·½·¨£¬¸æË߸÷½·¨Öƶ¨µÄ±êÇ©ÒѾÕÒµ½¡£ÀàËÆÓëÁ÷ýÌåµÄ½ ......
/**
* Ö±½Ó²åÈëÅÅÐò,Ê×ÏȱȽÏa[n]Óëa[n-1]£¬ÔڱȽÏa[n]Óëa[n-2]
* */
public void sort0(double[] a){
for(int i = 0; i < a.length -1; i ++){
......
1. Ó¦Ó÷¶Î§
±¾¹æ·¶Ó¦ÓÃÓÚ²ÉÓÃJ2EE¹æ·¶µÄÏîÄ¿ÖУ¬ËùÓÐÏîÄ¿ÖеÄJAVA´úÂ루º¬JSP£¬SERVLET£¬JAVABEAN£¬EJB£©¾ùÓ¦×ñÊØÕâ¸ö¹æ·¶¡£Í¬Ê±£¬Ò²¿É×÷ΪÆäËüÏîÄ¿µÄ²Î¿¼¡£
2. Éè¼ÆÀàºÍ·½·¨
2.1 ´´½¨¾ßÓкÜÇ¿ÄÚ¾ÛÁ¦µÄÀà
·½·¨µÄÖØÒªÐÔÍùÍù±ÈÀàµÄÖØÒªÐÔ¸üÈÝÒ×Àí½â£¬·½·¨ÊÇÖ¸Ö´ÐÐÒ»¸öͳһº¯ÊýµÄÒ»¶Î´úÂë¡£Àà³£± ......
package debug;import java.io.*;import java.lang.Thread;class MyThread extends Thread{ public int x = 0; public void run(){ System.out.println(++x); }}class R implements Runnable{ private int x = 0; public void run(){ System.out.printl ......