JAVAµ¼Èëµ¼³öexcel²Ù×÷£¨jxl£©
±¾ÎÄת×Ôhttp://kingsui.javaeye.com/blog/154712
javaµ¼Èëµ¼³öexcel²Ù×÷(jxl)
Java½âÊÍExcelÊý¾Ý£¨jxl.jar°üµÄʹÓã©
¹Ø¼ü×Ö: java excel jxl.jar
jxl.jar °ü
ÏÂÔصØÖ·:
http://www.andykhan.com/jexcelapi/
ÕæʵÏÂÔصØÖ·:
http://www.andykhan.com/jexcelapi/download.html
ÍøÕ¾É϶ÔËüµÄÌØÕ÷ÓÐÈçÏÂÃèÊö£º
¡ñ Ö§³ÖExcel 95-2000µÄËùÓа汾
¡ñ Éú³ÉExcel 2000±ê×¼¸ñʽ
¡ñ Ö§³Ö×ÖÌå¡¢Êý×Ö¡¢ÈÕÆÚ²Ù×÷
¡ñ Äܹ»ÐÞÊε¥Ôª¸ñÊôÐÔ
¡ñ Ö§³ÖͼÏñºÍͼ±í
Ó¦¸Ã˵ÒÔÉϹ¦ÄÜÒѾÄܹ»´óÖÂÂú×ãÎÒÃǵÄÐèÒª¡£×î¹Ø¼üµÄÊÇÕâÌ×APIÊÇ´¿JavaµÄ£¬²¢²»ÒÀÀµWindowsϵͳ£¬¼´Ê¹ÔËÐÐÔÚLinuxÏ£¬ËüͬÑùÄܹ»ÕýÈ·µÄ´¦ÀíExcelÎļþ¡£ÁíÍâÐèҪ˵Ã÷µÄÊÇ£¬ÕâÌ×API¶ÔͼÐκÍͼ±íµÄÖ§³ÖºÜÓÐÏÞ£¬¶øÇÒ½ö½öʶ±ðPNG¸ñʽ¡£
´î½¨»·¾³
½«ÏÂÔغóµÄÎļþ½â°ü£¬µÃµ½jxl.jar£¬·ÅÈëclasspath£¬°²×°¾ÍÍê³ÉÁË¡£
»ù±¾²Ù×÷
Ò»¡¢´´½¨Îļþ
ÄâÉú³ÉÒ»¸öÃûΪ“²âÊÔÊý¾Ý.xls”µÄExcelÎļþ£¬ÆäÖеÚÒ»¸ö¹¤×÷±í±»ÃüÃûΪ“µÚÒ»Ò³”£¬´óÖÂЧ¹ûÈçÏ£º
Java´úÂë
/*
* Created on Dec 30, 2007
*
* To change the template for this generated file go to
* Window>Preferences>Java>Code Generation>Code and Comments
*/
package JExcelTest.standard;
import java.io.*;
import jxl.*;
import jxl.write.*;
/**
* @author Ken
*
* To change the template for this generated type comment go to
* Window>Preferences>Java>Code Generation>Code and Comments
*/
public class CreateXLS {
public static void main(String[] args) {
try {
&n
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
1) AbstractClass£¨³éÏóÀࣩ£º¶¨ÒåÁËÒ»µ½¶à¸öµÄ³éÏó·½·¨£¬ÒÔ¹©¾ßÌåµÄ×ÓÀàÀ´ÊµÏÖËüÃÇ£»¶øÇÒ»¹ÒªÊµÏÖÒ»¸öÄ£°å·½·¨£¬À´¶¨ÒåÒ»¸öËã·¨µÄ¹Ç¼Ü¡£¸ÃÄ£°å·½·¨²»½öµ÷ÓÃÇ°ÃæµÄ³éÏó·½·¨£¬Ò²¿ÉÒÔµ÷ÓÃÆäËûµÄ²Ù×÷£¬Ö»ÒªÄÜÍê³É×ÔÉíµÄʹÃü¡£
2) ConcreteClass£¨¾ßÌåÀࣩ£ºÊµÏÖ¸¸ÀàÖеijéÏó·½·¨ÒÔÍê³ÉËã·¨ÖÐÓëÌض¨×ÓÀàÏà¹ØµÄ²½Öè¡£
& ......
Ò»¡¢static
¡¡¡¡ÇëÏÈ¿´ÏÂÃæÕâ¶Î³ÌÐò£º
public class Hello{
public static void main(String[] args){ //(1)
System.out.println("Hello,world!"); //(2)
}
}
¡¡¡¡¿´¹ýÕâ¶Î³ÌÐò£¬¶ÔÓÚ´ó¶àÊýѧ¹ýJava
µÄ´ÓÀ´Ëµ£¬¶¼²»Ä°Éú¡£¼´Ê¹Ã»ÓÐѧ¹ýJava£¬¶øѧ¹ýÆäËüµÄ¸ß¼¶ÓïÑÔ£¬ÀýÈçC£¬ÄÇÄãÒ²Ó¦¸ÃÄÜ¿´¶®Õâ¶Î´úÂëµÄÒâË ......
import java.util.Timer;
import java.util.TimerTask;
public class TimerExample
{
/**
* JavaÖмÆʱÆ÷µÄʹÓÃ
* Time: 21:19 2010-1-5
*/
Timer localTimer;
public Ti ......
LDAPÊDZê×¼ÇáÁ¿Ä¿Â¼·ÃÎÊÐÒé(Lightweight Directory Access Protocol)£¬Í¨¹ýLDAP£¬Äã¿ÉÒÔ·ÃÎÊĿ¼ÖеÄÓû§ÐÅÏ¢£¬½øÐÐÓû§ÑéÖ¤¡£DominoR5/6Ö§³Ö±ê×¼µÄLDAP v3Ŀ¼·þÎñ¡£±¾ÎÄͨ¹ýÃèÊöʹÓÃJNDI·ÃÎÊDominoĿ¼µÄ¹ý³Ì£¬Îª´ó¼Ò½éÉÜÈçºÎ³ä·ÖÀûÓûú¹¹ÖÐÒÑÓеÄDominoĿ¼×ÊÔ´¡£±¾ÎÄËùÊöµÄ·½·¨Ò²ÊÊÓÃÓÚÆäËûÖ§³ÖLDAP v3µÄĿ¼·þÎñÆ÷¡£
......