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

ÀûÓÃJAVA¶ÁÈ¡EXCELÎļþ


1 ´ÓExcelÎļþ¶ÁÈ¡Êý¾Ý±í
Java Excel API¼È¿ÉÒÔ´Ó±¾µØÎļþϵͳµÄÒ»¸öÎļþ(.xls)£¬Ò²¿ÉÒÔ´ÓÊäÈëÁ÷ÖжÁÈ¡ExcelÊý¾Ý±í¡£¶ÁÈ¡ExcelÊý¾Ý±íµÄµÚÒ»²½ÊÇ´´½¨Workbook(ÊõÓ¹¤×÷±¡)£¬ÏÂÃæµÄ´úÂëƬ¶Î¾ÙÀý˵Ã÷ÁËÓ¦¸ÃÈçºÎ²Ù×÷£º
import java.io.*;
import jxl.*;
try
{
//¹¹½¨Workbook¶ÔÏó, Ö»¶ÁWorkbook¶ÔÏó
    //Ö±½Ó´Ó±¾µØÎļþ´´½¨Workbook
//´ÓÊäÈëÁ÷´´½¨Workbook
    InputStream is = new FileInputStream(sourcefile);
    jxl.Workbook rwb = Workbook.getWorkbook(is);
}
catch (Exception e)
{
    e.printStackTrace();
}
Ò»µ©´´½¨ÁËWorkbook£¬ÎÒÃǾͿÉÒÔͨ¹ýËüÀ´·ÃÎÊExcel Sheet(ÊõÓ¹¤×÷±í)¡£
//»ñÈ¡µÚÒ»ÕÅSheet±í
Sheet rs = rwb.getSheet(0);
ÎÒÃǼȿÉÄÜͨ¹ýSheetµÄÃû³ÆÀ´·ÃÎÊËü£¬Ò²¿ÉÒÔͨ¹ýϱêÀ´·ÃÎÊËü¡£Èç¹ûͨ¹ýϱêÀ´·ÃÎʵĻ°£¬Òª×¢ÒâµÄÒ»µãÊÇϱê´Ó0¿ªÊ¼£¬¾ÍÏñÊý×éÒ»Ñù¡£
Ò»µ©µÃµ½ÁËSheet£¬ÎÒÃǾͿÉÒÔͨ¹ýËüÀ´·ÃÎÊExcel Cell(ÊõÓµ¥Ôª¸ñ)¡£²Î¿¼ÏÂÃæµÄ´úÂëƬ¶Î£º//»ñÈ¡µÚÒ»ÐУ¬µÚÒ»ÁеÄÖµ,ÁкÅÔÚÇ°Ãæ,ÐкÅÔÚºóÃæ
Cell c00 = rs.getCell(0, 0);
String strc00 = c00.getContents();
//»ñÈ¡µÚÒ»ÐУ¬µÚ¶þÁеÄÖµ
Cell c10 = rs.getCell(1, 0);
String strc10 = c10.getContents();
//»ñÈ¡µÚ¶þÐУ¬µÚ¶þÁеÄÖµ
Cell c11 = rs.getCell(1, 1);
String strc11 = c11.getContents();
System.out.println("Cell(0, 0)" + " value : " + strc00 + "; type : " + c00.getType());
System.out.println("Cell(1, 0)" + " value : " + strc10 + "; type : " + c10.getType());
System.out.println("Cell(1, 1)" + " value : " + strc11 + "; type : " + c11.getType());
Èç¹û½ö½öÊÇÈ¡µÃCellµÄÖµ£¬ÎÒÃÇ¿ÉÒÔ·½±ãµØͨ¹ýgetContents()·½·¨£¬Ëü¿ÉÒÔ½«ÈκÎÀàÐ͵ÄCellÖµ¶¼×÷Ϊһ¸ö×Ö·û´®·µ»Ø¡£Ê¾Àý´úÂëÖÐCell(0, 0)ÊÇÎı¾ÐÍ£¬Cell(1, 0)ÊÇÊý×ÖÐÍ£¬Cell(1,1)ÊÇÈÕÆÚÐÍ£¬Í¨¹ýgetContents()£¬ÈýÖÖÀàÐ͵ķµ»ØÖµ¶¼ÊÇ×Ö·ûÐÍ¡£
Èç¹ûÓÐÐèÒªÖªµÀCellÄÚÈݵÄÈ·ÇÐÀàÐÍ£¬APIÒ²ÌṩÁËһϵÁеķ½·¨¡£²Î¿¼ÏÂÃæµÄ´úÂëƬ¶Î£ºString strc00 = null;
double strc10 = 0.00;
Date strc11 = null;
Cell c00 = rs.getCell(0, 0);
Cell c10 = rs.getCell(1, 0);
Cell c11 = rs.getCell(1, 1);
if(c00.getType() == CellType.LABEL)
{
LabelCell labelc00 = (LabelCell)c00;
str


Ïà¹ØÎĵµ£º

Java NIO APIÏê½â

 
Java NIO APIÏê½â
ÔÚJDK
1.4ÒÔÇ°£¬JavaµÄIO²Ù×÷¼¯ÖÐÔÚjava.ioÕâ¸ö°üÖУ¬ÊÇ»ùÓÚÁ÷µÄ×èÈû£¨blocking£©API¡£¶ÔÓÚ´ó¶àÊýÓ¦ÓÃÀ´Ëµ£¬ÕâÑùµÄAPIʹÓúܷ½
±ã£¬È»¶ø£¬Ò»Ð©¶ÔÐÔÄÜÒªÇó½Ï¸ßµÄÓ¦Óã¬ÓÈÆäÊÇ·þÎñ¶ËÓ¦Óã¬ÍùÍùÐèÒªÒ»¸ö¸üΪÓÐЧµÄ·½Ê½À´´¦ÀíIO¡£´ÓJDK 1.4Æð£¬NIO
API×÷Ϊһ¸ö»ùÓÚ»º³åÇø£¬²¢ÄÜÌṩ·Ç×èÈû(non-blo ......

JavaѹËõÀà¿âµÄʹÓà 3.Apache AntÖеĴò°ü¡¢Ñ¹ËõÀà¿â

¡¡¡¡inkfishÔ­´´£¬ÇëÎðÉÌÒµÐÔÖÊתÔØ£¬×ªÔØÇë×¢Ã÷À´Ô´£¨http://blog.csdn.net/inkfish£©¡£
¡¡¡¡ÕâÀïÐèÒª¹Ø×¢µÄÊÇBZIP2¸ñʽ£¬¾­¹ý²âÊÔ£¬×ÜÊÇÎÞ·¨ÕýȷѹËõ£¬Ô­Òòδ֪£¬¶øapache commons bzip2¸ñʽµÄÎļþѹËõÕý³£¡££¨À´Ô´£ºhttp://blog.csdn.net/inkfish£©
Ant ZIPѹËõ£º£¨À´Ô´£ºhttp://blog.csdn.net/inkfish£©
package stu ......

JavaÊý¾ÝѹËõ¸ñʽ³ÌÐòÉè¼Æ·½·¨Ö®JARѹËõ¸ñʽ

1¡¢JAR¸ñʽÎļþ½éÉÜ
ÔÚJDK1.1°æÖУ¬¶¨ÒåÁËÓÃÓÚ½«ÓëJavaÓ¦ÓóÌÐòÏà¹ØµÄ¶à¸öÎļþÒÔ¼°Ïà¹Ø×ÊÔ´ÕûºÏÔÚÒ»ÆðµÄÊý¾ÝÎļþÀàÐÍ£­JAR¡£Ò²Ðí¶ÁÕß»á×¢Òâµ½£ºSunÒÔ¼°ÆäËü¹«Ë¾·¢²¼µÄ¶àÖÖÀàÐÍJava¿â¶¼ÊÇÒÔJARÐÎʽ½øÐÐÎļþѹËõºÍ·â×°µÄ¡£
´Ó±¾ÖÊÉϽ²£¬JARѹËõÎļþ²ÉÓÃZIP¸ñʽ½øÐÐÊý¾ÝѹËõ¡£ÓÉÓÚ×î³õÒýÈëJARÊý¾ÝѹËõÀàÐ͵ÄÄ¿µÄÔÚÓÚ½«¿ª·¢Íê ......

JavaÍøÂç±à³Ì1

       InetAddressÀà´ú±íIPµØÖ·£¬ÓÐÁ½¸ö×ÓÀ࣬Inet4Address£¬Inet6Address´ú±íIPV4ºÍIPv6£¬Ã»Óй¹Ôì·½·¨£¬µ«ÊÇÌṩ¸öÁËÁ½¸ö¾²Ì¬·½·¨À´»ñÈ¡InetAddressʵÀý£ºgetByName(String host):¸ù¾ÝÖð¾ä»ñÈ¡¶ÔÓ¦µÄInetAddress¶ÔÏó£»getByAddress(byte[]addr):¸ù¾ÝԭʼIPµØÖ·À´»ñÈ¡¶ÔÓ¦µÄInetAddress¶ÔÏ ......

javaÉú²úÕßÏû·ÑÕß

ÌâÄ¿£ºÇëÓöàÏß³ÌʵÏÖÒ»¸öÉú²úÕßÀàºÍÒ»¸öÏû·ÑÕßÀ࣬Éú²úÕßËæ»úÉú³É20¸ö×Ö·û£¬Ïû·ÑÕß½«×Ö·û´òÓ¡µ½¿ØÖÆ̨¡£
class SyncStack{ //ͬ²½¶ÑÕ»Àà
¡¡¡¡¡¡private int index = 0; //¶ÑÕ»Ö¸Õë³õʼֵΪ0
¡¡¡¡¡¡private char []buffer = new char[6]; //¶ÑÕ»ÓÐ6¸ö×Ö·ûµÄ¿Õ¼ä
¡¡¡¡¡¡public synchronized void push(char c){ //¼ÓÉ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ