jxl.jar°ü¼ò½é/java²Ù×÷excel jxl.jarÏÂÔØ
ÏÂÔØµØÖ·:
http://www.andykhan.com/jexcelapi/ µ±Ç°µÄ×î¸ß°æ±¾ÊÇ2.6¡£
ÕæÊµÏÂÔØµØÖ·:
http://www.andykhan.com/jexcelapi/download.html
×÷ÕßµÄÍøÕ¾É϶ÔËüµÄÌØÕ÷ÓÐÈçÏÂÃèÊö£º
¡ñ Ö§³ÖExcel 95-2000µÄËùÓа汾
¡ñ Éú³ÉExcel 2000±ê×¼¸ñʽ
¡ñ Ö§³Ö×ÖÌå¡¢Êý×Ö¡¢ÈÕÆÚ²Ù×÷
¡ñ Äܹ»ÐÞÊε¥Ôª¸ñÊôÐÔ
¡ñ Ö§³ÖͼÏñºÍͼ±í
Ó¦¸Ã˵ÒÔÉϹ¦ÄÜÒѾÄܹ»´óÖÂÂú×ãÎÒÃǵÄÐèÒª¡£×î¹Ø¼üµÄÊÇÕâÌ×APIÊÇ´¿JavaµÄ£¬²¢²»ÒÀÀµWindowsϵͳ£¬¼´Ê¹ÔËÐÐÔÚLinuxÏ£¬ËüͬÑùÄܹ»ÕýÈ·µÄ´¦ÀíExcelÎļþ¡£ÁíÍâÐèҪ˵Ã÷µÄÊÇ£¬ÕâÌ×API¶ÔͼÐκÍͼ±íµÄÖ§³ÖºÜÓÐÏÞ£¬¶øÇÒ½ö½öʶ±ðPNG¸ñʽ¡£
´î½¨»·¾³
½«ÏÂÔØºóµÄÎļþ½â°ü£¬µÃµ½jxl.jar£¬·ÅÈëclasspath£¬°²×°¾ÍÍê³ÉÁË¡£
»ù±¾²Ù×÷
Ò»¡¢´´½¨Îļþ
ÄâÉú³ÉÒ»¸öÃûΪ“²âÊÔÊý¾Ý.xls”µÄExcelÎļþ£¬ÆäÖеÚÒ»¸ö¹¤×÷±í±»ÃüÃûΪ“µÚÒ»Ò³”£¬´óÖÂЧ¹ûÈçÏ£º
´úÂ루CreateXLS.java£©£º
//Éú³ÉExcelµÄÀà
import java.io.*;
import jxl.*;
import jxl.write.*;
public class CreateXLS
{
public static void main(String args[])
{
try
{
//´ò¿ªÎļþ
WritableWorkbook book=
Workbook.createWorkbook(new File(“²âÊÔ.xls”));
//Éú³ÉÃûΪ“µÚÒ»Ò³”µÄ¹¤×÷±í£¬²ÎÊý0±íʾÕâÊǵÚÒ»Ò³
WritableSheet sheet=book.createSheet(“µÚÒ»Ò³”,0);
//ÔÚLabel¶ÔÏóµÄ¹¹Ôì×ÓÖÐÖ¸Ãûµ¥Ôª¸ñλÖÃÊǵÚÒ»ÁеÚÒ»ÐÐ(0,0)
//ÒÔ¼°µ¥Ôª¸ñÄÚÈÝΪtest
Label label=new Label(0,0,”test”);
//½«¶¨ÒåºÃµÄµ¥Ôª¸ñÌí¼Óµ½¹¤×÷±íÖÐ
sheet.addCell(label);
/*Éú³ÉÒ»¸ö±£´æÊý×ֵĵ¥Ôª¸ñ
±ØÐëʹÓÃNumberµÄÍêÕû°ü·¾¶£¬·ñÔòÓÐÓï·¨ÆçÒå
µ¥Ôª¸ñλÖÃÊǵڶþÁУ¬µÚÒ»ÐУ¬ÖµÎª789.123*/
jxl.write.Number number = new jxl.write.Number(1,0,789.123);
sheet.addCell(number);
//дÈëÊý¾Ý²¢¹Ø±ÕÎļþ
book.write();
book.close();
}catch(Exception e)
{
System.out.p
Ïà¹ØÎĵµ£º
Javaѧϰ´ÓÈëÃŵ½¾«Í¨
Ò»¡¢ JDK (Java Development Kit)
JDKÊÇÕû¸öJavaµÄºËÐÄ£¬°üÀ¨ÁËJavaÔËÐл·¾³£¨Java Runtime Envirnment£©£¬Ò»¶ÑJava¹¤¾ßºÍJava»ù´¡µÄÀà¿â(rt.jar)¡£²»ÂÛʲôJavaÓ¦Ó÷þÎñÆ÷ʵÖʶ¼ÊÇÄÚÖÃÁËij¸ö°æ±¾µÄJDK¡£Òò´ËÕÆÎÕJDKÊÇѧºÃJavaµÄµÚÒ»²½¡£×îÖ÷Á÷µÄJ ......
Java
Á÷²Ù×÷
¶ÔÓÚÎÒÃdz£ÓõÄGBKÖУ¬Ó¢ÎÄÊÇÕ¼ÓÃ1¸ö×Ö½Ú£¬ÖÐÎÄÊÇ2¸ö
¶ÔÓÚUTF-8£¬Ó¢ÎÄÊÇ1¸ö£¬ÖÐÎÄÊÇ3¸ö
¶ÔÓÚUnicode£¬Ó¢ÎÄÖÐÎͼÊÇ2¸ö
Java
µÄÁ÷²Ù×÷·ÖΪ×Ö½ÚÁ÷ºÍ×Ö·ûÁ÷Á½ÖÖ¡£
1¡¢
×Ö½ÚÁ÷
ËùÓеĶÁ²Ù×÷¶¼¼Ì³Ð×ÔÒ»¸ö¹«¹²³¬Àà
java
.io.InputStream
Àà¡£
ËùÓеÄд²Ù×÷¶¼¼Ì³Ð×ÔÒ ......
/**
SimpleDateFormatº¯ÊýÓï·¨£º
G Äê´ú±êÖ¾·û
y Äê
M ÔÂ
d ÈÕ
h ʱ ÔÚÉÏÎç»òÏÂÎç (1~12)
H ʱ ÔÚÒ»ÌìÖÐ (0~23)
m ·Ö
s Ãë
S ºÁÃë
E ÐÇÆÚ
D Ò»ÄêÖеĵڼ¸Ìì
F Ò»ÔÂÖеڼ¸¸öÐÇÆÚ¼¸
w Ò»Äê ......
quartzÊǸÉɶµÄ£¿ ÈÎÎñµ÷¶ÈÓõÄ
ÈÎÎñµ÷¶ÈÊǸÉɶµÄ£¿¾ÍÊÇÔÚÔ¤¶¨µÄʱ¼ä×öÔ¤¶¨µÄÊÂ
1.ÔÚquartÍøÕ¾ÏÂ×îеÄJAR°ü
2.½¨¸öÏîÄ¿£¬°ÑquartzµÄJAR°ü¼ÓÈëµ½ÏîÄ¿
3.н¨Ò»¸öÈÎÎñ
public class MyJob implements org.quartz.Job {
@Override
public void execute(JobExecutionContext arg0) throws JobExecutionExceptio ......
×î½ü¼¸Ìì,Ò»Ö±ÔÚÑо¿flex,˵¾äʵÔÚµÄ,ÆäÖеĿàÄÕ²»ÊÇÒ»¾ä»°Á½¾ä»°ÄÜ˵Çå³þµÄ.ûÓнӴ¥¹ý°¡!²»¹ýÏÖÔÚ×ÜËãÊǰÑÊý¾Ý¿âÁ¬ÉÏÁË,×ö³öÁË×Ô¼ºÏëÒªµÄ¶«Î÷.·Ï»°ÉÙ˵,ÏÖÔÚÄØ,ÎҾͰÑÎÒ×öµÄ´úÂëÌù³öÀ´,¸ø´ó¼Ò¿´¿´,¶àÌᱦ¹óÒâ¼û.
ÎÒÓõÄÊÇjdbcµÄÁ¬½Ó·½Ê½(hibernateµÄÁ¬½Ó·½Ê½ÎÒ¿´ÍøÉÏÓÐ,ËùÒԾͲ»Ìù³öÀ´ÁË)
1.flex´úÂë
<?xml version ......