ʹÓÃ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.util.DateÀàÀ´ÊµÏÖ£¬²¢½áºÏjava.text.DateFormatÀàÀ´ÊµÏÖʱ¼äµÄ¸ñʽ»¯£¬¿´ÏÂÃæ´úÂ룺
import java.util.*;
import java.text.*;
//ÒÔÏÂĬÈÏʱ¼äÈÕÆÚÏÔʾ·½Ê½¶¼ÊǺºÓïÓïÑÔ·½Ê½
//Ò»°ãÓïÑÔ¾ÍĬÈϺºÓï¾Í¿ÉÒÔÁË£¬Ê±¼äÈÕÆÚµÄ¸ñʽĬÈÏΪMEDIUM·ç¸ñ£¬±ÈÈ磺2008-6-16 20:54:53
//ÒÔÏÂÏÔʾµÄÈ ......
(Ò»)³ÌÐò¿ª·¢£¬´æÔںܶàÎÊÌâ:Ê×ÏÈ£¬Ã¿Ò»´ÎWebÇëÇó¶¼Òª½¨Á¢Ò»´ÎÊý¾Ý¿âÁ¬½Ó¡£½¨Á¢Á¬½ÓÊÇÒ»¸ö·ÑʱµÄ»î¶¯£¬Ã¿´Î¶¼µÃ»¨·Ñ0.05s¡«1sµÄʱ¼ä£¬¶øÇÒϵͳ»¹Òª·ÖÅäÄÚ´æ×ÊÔ´¡£Õâ¸öʱ¼ä¶ÔÓÚÒ»´Î»ò¼¸´ÎÊý¾Ý¿â²Ù×÷£¬»òÐí¸Ð¾õ²»³öϵͳÓжà´óµÄ¿ªÏú¡£¿ÉÊǶÔÓÚÏÖÔÚµÄWebÓ¦Óã¬ÓÈÆäÊÇ´óÐ͵ç×ÓÉÌÎñÍøÕ¾£¬Í¬Ê±Óм¸ ......
File f=new File("DerectoryName");
String []results=f.list();
import java.io.*;
¡¡¡¡public class listFile
¡¡¡¡{ &nb ......
×î¼Ñ´ð°¸
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ÎļþÃû³Æ¿ÉÒÔ ......