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

ʹÓÃJAVAͨ¹ýJXL(JExcel)¶¯Ì¬Éú³ÉExcelÎļþ


 
ÉÏ´Î談過ÁËʹÓÃiText產ÉúPDF檔£¬這´Î換³É來談談ʹÓÃJExcel來產ÉúEXCEL檔µÄ·½·¨¡£
Ê×ÏÈ£¬Ïȵ½ËûµÄSourceForgeÖ÷頁ÃædownloadÏà關µÄAPI檔°¸¡£
http://sourceforge.net/projects/jexcelapi/
»ò
http://www.andykhan.com/jexcelapi/download.html
當È»£¬ËûÒ²ÊÇOpenSourceµÄÔª¼þ¡£
ÏÂÁÐ為ÆäTutorial½Ì學£º
http://www.andykhan.com/jexcelapi/tutorial.html
Ò»ÇоÍ緒áᣬÄǾÍ準備ÉÏ·ÁË¡£
ÏÂ載ÏÂ來µÄ壓縮檔½â開áᣬ¿ÉÒÔÕÒµ½jxl.jar£¬ÏÈ將´Ë檔°¸¼ÓÈëÄãµÄClasspathÖаɣ¡
1. ÏȽ¨Á¢Workbook
Ò²¾ÍÊÇÕû·ÝµÄExcel檔°¸£¬¿ÉÖ¸¶¨檔Ãû¡£
Workbook workbook = Workbook.getWorkbook(new File("test.xls"));
2. ½¨Á¢Sheet
Ò²¾ÍÊÇÿ個Excel檔°¸ÏÂÃæ¿ÉÒÔÌøtagµÄsheet±í¡£
Sheet sheet = workbook.createSheet("ÎÒµÄExcel±í", 0);
µÚÒ»個參數ÊÇsheet name£¬µÚ¶þ個參數ÊǵÚ幾張sheet£¬當È»indexÊÇÓÉ0開ʼËã¡£
3. ½¨Á¢×ÖÐÍ
WritableFont chFont11w = new WritableFont(WritableFont.TIMES, 11);
chFont11w.setColour(Colour.WHITE);
ÏȽ¨Á¢Ò»個WritableFontµÄinstance£¬ÆäconstructorµÄµÚÒ»個參數ÊÇÖ¸¶¨×ÖÐÍ£¬µÚ¶þ個ÊÇ×ÖÐÍ´óС¡£
ÆäÖÐ×ÖÐ͵IJ¿·Ý£¬¿ÉÒÔʹÓÃWritableFontËùÌṩ預設µÄÒ»¶Ñstatic³£數來Ö¸¶¨£¬
Ò²¿ÉÒÔÖ±½Ó輸Èëstring£¬±ÈÈç´ò"標¿¬體"£¬µ½時產ÉúµÄ×ÖÐ;Í會ÒÀÕÕÄãËùÖ¸¶¨µÄ來顯ʾ¡£
¶øsetColourÊÇÖ¸¶¨´Ë×ÖÐ͵Ä顏É«£¬這個²¿·Ý¾ÍÂé煩¡£
(ÓÉcolour這個×Ö來¿´£¬ºÜ顯È»µÄJExcel應ÊÇÓ¢國Ïà關µÄÈË開發µÄ:P  ·´Õý總Ö®²»會ÊÇÃÀ國)
顏É«為ʲ麼Âé煩ÄØ£¿ÔÚJExcel裡Ãæ£¬Colour class並²»Ìṩpublic constructor讓user×Ô¼ºÖ¸¶¨RGBµÄ顏É«£¬
ËùÒÔÄãÖ»ÄÜ從ColourÖÐÒ»¶ÑµÄstatic³£數顏É«來Ö¸¶¨£¬Ö®Ç°為ÁË這個問題還Ñо¿ÁËÒ»ÏÂËûµÄԭʼ


Ïà¹ØÎĵµ£º

java»ñÈ¡µ±Ç°Ê±¼ä£¨×ªÔØ£©


ÓÐÁ½ÖÖ·½·¨£º
·½·¨Ò»£ºÓÃjava.util.DateÀàÀ´ÊµÏÖ£¬²¢½áºÏjava.text.DateFormatÀàÀ´ÊµÏÖʱ¼äµÄ¸ñʽ»¯£¬¿´ÏÂÃæ´úÂ룺
import java.util.*;
import java.text.*;
//ÒÔÏÂĬÈÏʱ¼äÈÕÆÚÏÔʾ·½Ê½¶¼ÊǺºÓïÓïÑÔ·½Ê½
//Ò»°ãÓïÑÔ¾ÍĬÈϺºÓï¾Í¿ÉÒÔÁË£¬Ê±¼äÈÕÆÚµÄ¸ñʽĬÈÏΪMEDIUM·ç¸ñ£¬±ÈÈ磺2008-6-16 20:54:53
//ÒÔÏÂÏÔʾµÄÈ ......

JAVAÖÐÊý¾Ý¿âÁ¬½Ó³ØµÄ¶¯Ì¬ÊµÏÖ

     (Ò»)³ÌÐò¿ª·¢£¬´æÔںܶàÎÊÌâ:Ê×ÏÈ£¬Ã¿Ò»´ÎWebÇëÇó¶¼Òª½¨Á¢Ò»´ÎÊý¾Ý¿âÁ¬½Ó¡£½¨Á¢Á¬½ÓÊÇÒ»¸ö·ÑʱµÄ»î¶¯£¬Ã¿´Î¶¼µÃ»¨·Ñ0.05s¡«1sµÄʱ¼ä£¬¶øÇÒϵͳ»¹Òª·ÖÅäÄÚ´æ×ÊÔ´¡£Õâ¸öʱ¼ä¶ÔÓÚÒ»´Î»ò¼¸´ÎÊý¾Ý¿â²Ù×÷£¬»òÐí¸Ð¾õ²»³öϵͳÓжà´óµÄ¿ªÏú¡£¿ÉÊǶÔÓÚÏÖÔÚµÄWebÓ¦Óã¬ÓÈÆäÊÇ´óÐ͵ç×ÓÉÌÎñÍøÕ¾£¬Í¬Ê±Óм¸ ......

javaÁгöijÎļþ¼ÐϵÄËùÓÐÎļþ


File   f=new   File("DerectoryName");      
  String   []results=f.list();   
  
import java.io.*;    
¡¡¡¡public class listFile    
¡¡¡¡{  &nb ......

javaµ÷ÓÃdllÀý×Ó


×î¼Ñ´ð°¸
1. ±àд·¶ÀýÎĵµ
public class TestNative
{
private native static int Max(int a,int b);
public static void main(String[] args)
{
System.out.println(Max(4,5));
}
static
{
System.loadLibrary("VCdll");
}
}
ÆäÖÐ
LoadLibraryÖеÄDLLÎļþÃû³Æ¿ÉÒÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ