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,
Ïà¹ØÎĵµ£º
Ò»¡¢Axis°²×° 1¡¢»·¾³ J2SE SDK 1.3 or 1.4: ÎÒʹÓà 1.4.2 Servlet Container: ÎÒʹÓõÄTomcat 5.0
2¡¢µ½ http://ws.apache.org/Axis/ÍøÕ¾ÏÂÔØAxis°²×°°ü
3¡¢½âѹËõ°²×°°ü£¬½«Axis_UNZIP_PATH\Axis-version\webappsϵÄAxis°ü¿½±´µ½TOMCAT_HOME\webapps\Ï£¬ÒÔÏÂÔ¼¶¨Axis_HOMEΪ¸ÃTOMCAT_HOME\webapps\AxisĿ¼
4¡¢Æô¶¯ ......
ΪʲôҪʹÓÃ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 ......
ʲôÊÇsocket
³¤Á¬½ÓÓë¶ÌÁ¬½Ó
Ëùν³¤Á¬½Ó£¬Ö¸ÔÚÒ»¸öTCPÁ¬½ÓÉÏ¿ÉÒÔÁ¬Ðø·¢ËͶà¸öÊý¾Ý°ü£¬ÔÚTCPÁ¬½Ó±£³ÖÆÚ¼ä£¬Èç¹ûûÓÐÊý¾Ý°ü·¢ËÍ£¬ÐèҪ˫·½·¢¼ì²â°üÒÔά³Ö´ËÁ¬½Ó£¬Ò»°ãÐèÒª×Ô¼º×öÔÚÏßά³Ö¡£
¶ÌÁ¬½ÓÊÇָͨÐÅË«·½ÓÐÊý¾Ý½»»¥Ê±£¬¾Í½¨Á¢Ò»¸öTCPÁ¬½Ó£¬Êý¾Ý·¢ËÍÍê³Éºó£¬Ôò¶Ï¿ª´ËTCPÁ¬½Ó£¬Ò»°ãÒøÐж¼Ê¹ÓöÌÁ¬½Ó¡£
±ÈÈçht ......
1.¼Ì³Ð£ºÊÇÖ¸ÏÈ´´½¨Ò»¸ö¹²ÓÐÊôÐÔµÄÒ»°ãÀ࣬¸ù¾Ý¸ÃÒ»°ãÀàÔÙ´´½¨¾ßÓÐÌØÊâÊôÐÔµÄÐÂÀ࣬ÐÂÀà¼Ì³ÐÒ»°ãÀàµÄ״̬ºÍÐÐΪ£¬²¢¸ù¾ÝÐèÒªÔö¼Ó×Ô
¼ºµÄеÄ״̬ºÍÐÐΪ
Óɼ̳жøµÃµ½µÄÀà³ ......