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

Java ¶ÁдExcelÎļþ £¨¶þ£©

JAVA EXCEL API¼ò½é
Java ExcelÊÇÒ»¿ª·ÅÔ´ÂëÏîÄ¿£¬Í¨¹ýËüJava¿ª·¢ÈËÔ±¿ÉÒÔ¶ÁÈ¡ExcelÎļþµÄÄÚÈÝ¡¢´´½¨ÐµÄExcelÎļþ¡¢¸üÐÂÒѾ­´æÔÚµÄExcelÎļþ¡£Ê¹ÓøÃAPI·ÇWindows²Ù×÷ϵͳҲ¿ÉÒÔͨ¹ý´¿JavaÓ¦ÓÃÀ´´¦ÀíExcelÊý¾Ý±í¡£ÒòΪÊÇʹÓÃJava±àдµÄ£¬ËùÒÔÎÒÃÇÔÚWebÓ¦ÓÃÖпÉÒÔͨ¹ýJSP¡¢ServletÀ´µ÷ÓÃAPIʵÏÖ¶ÔExcelÊý¾Ý±íµÄ·ÃÎÊ¡£
ÏÖÔÚ·¢²¼µÄÎȶ¨°æ±¾ÊÇV2.0£¬ÌṩÒÔϹ¦ÄÜ£º
´ÓExcel 95¡¢97¡¢2000µÈ¸ñʽµÄÎļþÖжÁÈ¡Êý¾Ý£»
¶ÁÈ¡Excel¹«Ê½£¨¿ÉÒÔ¶ÁÈ¡Excel 97ÒÔºóµÄ¹«Ê½£©£»
Éú³ÉExcelÊý¾Ý±í£¨¸ñʽΪExcel 97£©£»
Ö§³Ö×ÖÌå¡¢Êý×Ö¡¢ÈÕÆÚµÄ¸ñʽ»¯£»
Ö§³Öµ¥Ôª¸ñµÄÒõÓ°²Ù×÷£¬ÒÔ¼°ÑÕÉ«²Ù×÷£»
ÐÞ¸ÄÒѾ­´æÔÚµÄÊý¾Ý±í£»
ÏÖÔÚ»¹²»Ö§³ÖÒÔϹ¦ÄÜ£¬µ«²»¾Ã¾Í»áÌṩÁË£º
1. ²»Äܹ»¶Áȡͼ±íÐÅÏ¢£»
2. ¿ÉÒÔ¶Á£¬µ«ÊDz»ÄÜÉú³É¹«Ê½£¬ÈκÎÀàÐ͹«Ê½×îºóµÄ¼ÆËãÖµ¶¼¿ÉÒÔ¶Á³ö£»
Ê×ÏÈÐèÒª´ÓÍøÉÏÏÂÒ»¸ö jexcelapi.zip°ü, ÀïÃæÓÐÎÒÃÇËùÐèÒªµÄjxl.jarÎļþ.
ÏÂÔØµØÖ·: http://sourceforge.net/project/showfiles.php?group_id=79926
×Ô¼ºÐ´ÁËÒ»¸ö¼òµ¥µÄÀý×Ó!
WriteExcel.java
import java.io.File;
import java.io.IOException;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;
public class WriteExcel {
/**
* @param args
* @throws WriteException
* @throws RowsExceededException
*/
public static void main(String[] args) throws RowsExceededException, WriteException {
// TODO Auto-generated method stub
try {
//´´½¨¿ÉдÈëµÄExcel¹¤×÷²¾
WritableWorkbook wwb=Workbook.createWorkbook(new File("D://writeExcel.xls"));
//´´½¨¹¤×÷±í
WritableSheet ws=wwb.createSheet("Test Shee 1", 0);
//Ìí¼ÓLabel¶ÔÏó,µÚÒ»¸ö²ÎÊý´ú±íÁÐ,µÚ¶þ¸ö²ÎÊý´ú±íÐÐ.¶¼ÊÇ´Ó0¿ªÊ¼
Label labelC=new Label(5,0,"This is a Label cell");
Label labelD=new Label(6,0,"This is a Label cell");
Label labelE=new Label(7,0,"");
ws.addCell(labelC);
ws.addCell(labelD);
ws.addCell(labelE);

/*******************************Ìí¼Ó¶àÖÖÐÎʽÊý¾Ý·½·¨*******************************************


Ïà¹ØÎĵµ£º

ÈÕÆÚÀà¼Ó¼õ¼°JavaÖÐÈÕÆÚÀà²Ù×÷Ëã·¨´óÈ«

1.¼ÆËãijһÔ·ݵÄ×î´óÌìÊý
1Calendar time=Calendar.getInstance();
2time.clear();
3time.set(Calendar.YEAR,year); //year Ϊ int
4time.set(Calendar.MONTH,i-1);//×¢Òâ,Calendar¶ÔÏóĬÈÏÒ»ÔÂΪ0
5int day=time.getActualMaximum(Calendar.DAY_OF_MONTH);//±¾Ô·ݵÄÌìÊý
×¢£ºÔÚʹÓÃset·½·¨Ö®Ç°£¬±ØÐë ......

Java¿ªÔ´IDE

 Java Tools 
      Java ToolsÊÇÒ»¸öÇáÁ¿¼¶IDE£¬ÓÃÓÚ´´½¨¡¢±àÒë¡¢Ö´ÐС¢µ÷ÊÔJavaÓ¦ÓóÌÐòÓëapplets¡£Ëü»¹ÄÚÖÃÒ»¸öÎı¾±à¼­Æ÷ºÍÒ»¸öÓµÓÐÓû§²Ù
     ×÷½çÃæµÄJavaµ÷ÊÔÆ÷¡£ËüÒ×ÓÚʹÓÃÌØ±ðÊʺÏÓÚJava³õѧÕß¡£
Eclipse 
   Eclipseƽ̨ÊÇIBMÏò¿ª·¢ ......

ÀûÓÃjava¶ÁÈ¡ExcelÖеÄÊý¾Ý

ʹÓÃWindows²Ù×÷ϵͳµÄÅóÓѶÔExcel£¨µç×Ó±í¸ñ£©Ò»¶¨²»»áİÉú£¬µ«ÊÇҪʹÓÃJavaÓïÑÔÀ´²Ù×ÝExcelÎļþ²¢²»ÊÇÒ»¼þÈÝÒ×µÄÊ¡£ÔÚWebÓ¦ÓÃÈÕÒæÊ¢ÐеĽñÌ죬ͨ¹ýWebÀ´²Ù×÷ExcelÎļþµÄÐèÇóÔ½À´Ô½Ç¿ÁÒ£¬Ä¿Ç°½ÏΪÁ÷ÐеIJÙ×÷ÊÇÔÚJSP»òServlet Öд´½¨Ò»¸öCSV £¨comma separated values£©Îļþ£¬²¢½«Õâ¸öÎļþÒÔMIME£¬text/csvÀàÐÍ·µ»Ø¸øä¯ÀÀÆ ......

ÉÏ´«ÏÂÔØjspSmartUpload°üµÄʹÓÃ[Java]

ÉÏ´«ÏÂÔØjspSmartUpload°üµÄʹÓÃ[Java]
Ò»¡¢°²×°Æª
¡¡¡¡jspSmartUploadÊÇÓÉwww.jspsmart.comÍøÕ¾¿ª·¢µÄÒ»¸ö¿ÉÃâ·ÑʹÓõÄÈ«¹¦ÄܵÄÎļþÉÏ´«ÏÂÔØ×é¼þ£¬ÊÊÓÚǶÈëÖ´ÐÐÉÏ´«ÏÂÔØ²Ù×÷µÄJSPÎļþÖС£¸Ã×é¼þÓÐÒÔϼ¸¸öÌØµã£º
1¡¢Ê¹Óüòµ¥¡£ÔÚJSPÎļþÖнö½öÊéдÈýÎåÐÐJAVA´úÂë¾Í¿ÉÒԸ㶨ÎļþµÄÉÏ´«»òÏÂÔØ£¬·½±ã¡£
2¡¢ÄÜÈ«³Ì¿ØÖÆÉ ......

JavaµÄ°æ±¾

Java ƽ̨ÓÐÈý¸ö°æ±¾£¬ÕâʹÈí¼þ¿ª·¢ÈËÔ±¡¢·þÎñÌṩÉ̺ÍÉ豸Éú²úÉÌ¿ÉÒÔÕë¶ÔÌØ¶¨µÄÊг¡½øÐпª·¢£º
    * Java SE£¨Java Platform£¬Standard Edition£©¡£Java SE ÒÔǰ³ÆÎª J2SE¡£ËüÔÊÐí¿ª·¢ºÍ²¿ÊðÔÚ×ÀÃæ¡¢·þÎñÆ÷¡¢Ç¶Èëʽ»·¾³ºÍʵʱ»·¾³ÖÐʹÓÃµÄ Java Ó¦ÓóÌÐò¡£Java SE °üº¬ÁËÖ§³Ö Java Web ·þÎñ¿ª·¢µÄÀ࣬²¢Î ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ