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,
Ïà¹ØÎĵµ£º
ÒòΪÔÚ×öÁ´½ÓÀ´Ô´Í³¼ÆµÄʱºòÐèÒª°Ñ http://www.baidu.com/baidu?word= ... B%F7&tn=myie2dg ÕâÀàµÄURL±àÂ뻹ԳÉÃ÷ÎÄ×Ö´®£¬Ò»°ã´ó²¿·ÖµÄÍøÕ¾¶¼ÊÇÓÃÆÕͨµÄURL±àÂëÐÎʽ£¬ÈçÉÏÃæÁ´½ÓÖеÄbadu£¬ÕâÖַdz£ÈÝÒ×ת»»ºÍ»¹Ô£¬Java°üÀïÌṩÁËÁ½¸öÀàµÄ²»Í¬·½·¨URLEncode.encode()ºÍURLDecode.decode()Äܷdz£·½±ãʵÏÖ£¬µ ......
ΪʲôҪʹÓÃtomcat£¬jboosÕâÖÖ·þÎñÀ´ÔËÐÐÎÒÃǵĴúÂ룬Óкαػ¨Ôõô¶àÇ®ÂòIBm£¬BEAµÄ·þÎñÆ÷¡£²Ý£¨·ßÇàµÄÓïÆø£©£¬ÎÒÃÇÔÙÒ²²»¸ú±ðÈË×ß¡£
ÄѵÀÎÒÃÇ×Ô¼ºÐ´µÄ¶«Î÷¾Í²»¿É¿¿Âð£¿ÎÒÃÇ¿ª·¢ÎÒÃǵÄÏîÄ¿£¬ÐèÇóÎÒÃÇ×îÇå³þ£¬ÎÒÃÇÔõô×ö¸ÉÂﻹҪËûÃǹܣ¬SSHÊDZðÈËÌßÈ¥À´¡£
´Ó½ñÒÔºó£¬ÎÒ×Ô¼º¿ª·¢µÄjavaÆóÒµ³ÌÐò(tmd ÎÞ·¨¾ÍÊÇÇëÇó/ÏìӦģʽ ......
½«javaÏîÄ¿Éú³Éexe¿ÉÖ´ÐÐÎļþÈ«¹ý³Ì
2009Äê05ÔÂ10ÈÕ ÐÇÆÚÈÕ 16:30
Ò»¡¢Ê×ÏÈΪeclipse°²×°fatjar²å¼þ£¨Èç¹ûÄãµÄjarÏîÄ¿ÖÐÐèÒªÓõ½Í¼Æ¬¡¢Íⲿ³ÌÐòµÈÎļþʱҪÓô˲å¼þ´ò°ü³ÌÐò²ÅÄÜÕý³£ÔËÐУ©
°²×°·½Ê½ÓÐÁ½ÖÖ£º·½·¨1£ºÔÚÏß°²×°£¨ÍƼö£©
²½Ö裺
eclipse²Ëµ¥À¸ help >software updates >Find and install >Search f ......
/**
* Ö±½Ó²åÈëÅÅÐò,Ê×ÏȱȽÏ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.¼Ì³Ð£ºÊÇÖ¸ÏÈ´´½¨Ò»¸ö¹²ÓÐÊôÐÔµÄÒ»°ãÀ࣬¸ù¾Ý¸ÃÒ»°ãÀàÔÙ´´½¨¾ßÓÐÌØÊâÊôÐÔµÄÐÂÀ࣬ÐÂÀà¼Ì³ÐÒ»°ãÀàµÄ״̬ºÍÐÐΪ£¬²¢¸ù¾ÝÐèÒªÔö¼Ó×Ô
¼ºµÄеÄ״̬ºÍÐÐΪ
Óɼ̳жøµÃµ½µÄÀà³ ......