Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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,


Ïà¹ØÎĵµ£º

JAVAÆóÒµÓ¦Óõķ´Ë¼ ±àд×Ô¼ºµÄÈÝÆ÷ Ãû×ֽС¶ÎϾӡ·

ΪʲôҪʹÓÃtomcat£¬jboosÕâÖÖ·þÎñÀ´ÔËÐÐÎÒÃǵĴúÂ룬Óкαػ¨Ôõô¶àÇ®ÂòIBm£¬BEAµÄ·þÎñÆ÷¡£²Ý£¨·ßÇàµÄÓïÆø£©£¬ÎÒÃÇÔÙÒ²²»¸ú±ðÈË×ß¡£
ÄѵÀÎÒÃÇ×Ô¼ºÐ´µÄ¶«Î÷¾Í²»¿É¿¿Âð£¿ÎÒÃÇ¿ª·¢ÎÒÃǵÄÏîÄ¿£¬ÐèÇóÎÒÃÇ×îÇå³þ£¬ÎÒÃÇÔõô×ö¸ÉÂﻹҪËûÃǹܣ¬SSHÊDZðÈËÌßÈ¥À´¡£
´Ó½ñÒÔºó£¬ÎÒ×Ô¼º¿ª·¢µÄjavaÆóÒµ³ÌÐò(tmd ÎÞ·¨¾ÍÊÇÇëÇó/ÏìӦģʽ ......

jpythonµ÷ÓÃjavaÀàµÄÄ£°å


ʹÓÃJPypeÄ£¿éÈÃPythonµ÷ÓÃJAVAµÄÀà
Python idea!   2009-03-24 19:44   ÔĶÁ267   ÆÀÂÛ0  
×ֺţº ´ó´ó  ÖÐÖР СС
¿´¿´Àý×Ó¾ÍÖªµÀÀ²£¬ÕæÊÇΪPython£¨²»ÊÇJython£¬¶øÊÇCPython£©ÌṩÁËÇ¿´óÁ¦Á¿£¡
Ê×ÏÈÔÚjavaϽ¨Á¢Ò»¸öÔÙÒ²¼òµ¥²»¹ýµÄ°ü£º
package org.wg3i.t ......

»Ø¹ËJava±à³Ì˼ÏëÆª£¨¶þ£©

4¡¢Ïú»Ù¶ÔÏó JavaÖв»ÐèÒª³ÌÐòÔ±×Ô¼ºÈ¥Ïú»Ù¶ÔÏó£¬ÕâÊÇÎªÊ²Ã´ÄØ£¿ ÔÚC++ÖУ¬¶ÔÓÚ±äÁ¿¼°¶ÔÏóÉúÃüÖÜÆÚµÄά»¤Õ¼¾ÝÁË´óÁ¿µÄ±à³Ìʱ¼ä£¬ÒòΪ³ÌÐòÔ±ÐèÒªÖªµÀ±äÁ¿´æ»îµÄʱ¼ä£¬ÒÔ±ãÔÚÓÃÍêÖ®ºóÄܰÑËüÏú»Ù£¬²»È»»áÕ¼ÂúÄÚ´æ¿Õ¼ä£¬×èÈû³ÌÐò¡£Òò´ËJavaÔÚÉè¼ÆÊ±¶Å¾øÁËÕâÒ»ÎÊÌâ¡£ÄÇôJavaÊÇÔõô×öµÄÄØ£¬¿´ÏÂÃæµÄ½éÉÜ¡£ 4.1¡¢±äÁ¿×÷ÓÃÓò ×÷ÓÃÓ ......

JAVAÅÀ³æ

ÕâÊÇÒ»¸öwebËÑË÷µÄ»ù±¾³ÌÐò£¬´ÓÃüÁîÐÐÊäÈëËÑË÷Ìõ¼þ£¨ÆðʼµÄURL¡¢´¦ÀíurlµÄ×î´óÊý¡¢ÒªËÑË÷µÄ×Ö·û´®),
Ëü¾Í»áÖð¸ö¶ÔInternetÉϵÄURL½øÐÐʵʱËÑË÷,²éÕÒ²¢Êä³öÆ¥ÅäËÑË÷Ìõ¼þµÄÒ³Ãæ¡£ Õâ¸ö³ÌÐòµÄÔ­ÐÍÀ´×Ô¡¶java±à³ÌÒÕÊõ¡·£¬
ΪÁ˸üºÃµÄ·ÖÎö£¬Õ¾³¤È¥µôÁËÆäÖеÄGUI²¿·Ö£¬²¢ÉÔ×÷ÐÞ¸ÄÒÔÊÊÓÃjdk1.5¡£ÒÔÕâ¸ö³ÌÐòΪ»ù´¡£¬¿ÉÒÔд³öÔÚ» ......

javaÖеļ̳Ð

1.¼Ì³Ð£ºÊÇÖ¸ÏÈ´´½¨Ò»¸ö¹²ÓÐÊôÐÔµÄÒ»°ãÀ࣬¸ù¾Ý¸ÃÒ»°ãÀàÔÙ´´½¨¾ßÓÐÌØÊâÊôÐÔµÄÐÂÀ࣬ÐÂÀà¼Ì³ÐÒ»°ãÀàµÄ״̬ºÍÐÐΪ£¬²¢¸ù¾ÝÐèÒªÔö¼Ó×Ô
            ¼ºµÄеÄ״̬ºÍÐÐΪ
            Óɼ̳жøµÃµ½µÄÀà³ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ