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

Java²Ù×÷Excel Poi¼ò½é


 
Ò»£®POI¼ò½é
Jakarta POI ÊÇapacheµÄ×ÓÏîÄ¿£¬Ä¿±êÊÇ´¦Àíole2¶ÔÏó¡£ËüÌṩÁËÒ»×é²Ù×ÝWindowsÎĵµµÄJava API
Ŀǰ±È½Ï³ÉÊìµÄÊÇHSSF½Ó¿Ú£¬´¦ÀíMS Excel£¨97-2002£©¶ÔÏó¡£Ëü²»ÏóÎÒÃǽö½öÊÇÓÃcsvÉú³ÉµÄûÓиñʽµÄ¿ÉÒÔÓÉExcelת»»µÄ¶«Î÷£¬¶øÊÇÕæÕýµÄExcel¶ÔÏó£¬Äã¿ÉÒÔ¿ØÖÆÒ»Ð©ÊôÐÔÈçsheet,cellµÈµÈ¡£
¶þ£®HSSF¸Å¿ö
HSSF ÊÇHorrible SpreadSheet FormatµÄËõд£¬Ò²¼´“ÌÖÑáµÄµç×Ó±í¸ñ¸ñʽ”¡£Ò²ÐíHSSFµÄÃû×ÖÓе㻬»ü£¬¾Í±¾ÖʶøÑÔËüÊÇÒ»¸ö·Ç³£ÑÏËà¡¢Õý¹æµÄAPI¡£Í¨¹ýHSSF£¬Äã¿ÉÒÔÓô¿Java´úÂëÀ´¶ÁÈ¡¡¢Ð´Èë¡¢ÐÞ¸ÄExcelÎļþ¡£
HSSF Ϊ¶ÁÈ¡²Ù×÷ÌṩÁËÁ½ÀàAPI£ºusermodelºÍeventusermodel£¬¼´“Óû§Ä£ÐÍ”ºÍ“ʼþ-Óû§Ä£ÐÍ”¡£Ç°ÕߺܺÃÀí½â£¬ºóÕ߱ȽϳéÏ󣬵«²Ù×÷ЧÂÊÒª¸ßµÃ¶à¡£
Èý£®¿ªÊ¼±àÂë
1 £® ×¼±¸¹¤×÷
ÒªÇó:JDK 1.4+POI¿ª·¢°ü
2 £® EXCEL ½á¹¹
HSSFWorkbook excell Îĵµ¶ÔÏó½éÉÜ
HSSFSheet excellµÄ±íµ¥
HSSFRow excellµÄÐÐ
HSSFCell excellµÄ¸ñ×Óµ¥Ôª
HSSFFont excell×ÖÌå
HSSFName Ãû³Æ
HSSFDataFormat ÈÕÆÚ¸ñʽ
ÔÚpoi1.7ÖвÅÓÐÒÔÏÂ2Ï
HSSFHeader sheetÍ·
HSSFFooter sheetβ
ºÍÕâ¸öÑùʽ
HSSFCellStyle cellÑùʽ
¸¨Öú²Ù×÷°üÀ¨
HSSFDateUtil ÈÕÆÚ
HSSFPrintSetup ´òÓ¡
HSSFErrorConstants ´íÎóÐÅÏ¢±í
3 £®¾ßÌåÓ÷¨ÊµÀý £¨²ÉÓà usermodel £©
ÈçºÎ¶ÁExcel
¶ÁÈ¡ExcelÎļþʱ£¬Ê×ÏÈÉú³ÉÒ»¸öPOIFSFileSystem¶ÔÏó£¬ÓÉPOIFSFileSystem¶ÔÏó¹¹ÔìÒ»¸öHSSFWorkbook£¬¸ÃHSSFWorkbook¶ÔÏó¾Í´ú±íÁËExcelÎĵµ¡£ÏÂÃæ´úÂë¶ÁÈ¡ÉÏÃæÉú³ÉµÄExcelÎļþдÈëµÄÏûÏ¢×Ö´®£º
´úÂë
POIFSFileSystem fs=newPOIFSFileSystem(new FileInputStream("d:\test.xls"));    
HSSFWorkbook ¡¡wb = new HSSFWorkbook(fs);    
¡¡¡¡} catch (IOException e) {    
¡¡¡¡e.printStackTrace();    
¡¡¡¡}    
¡¡¡¡HSSFSheet sheet = wb.getSheetAt(0);    
¡¡¡¡HSSFRow row = sheet.getRow(0);    
¡¡¡¡HSSFCell cell = row.getCell((short) 0);    
¡¡¡¡String msg = cell.getStringCellValue();  
POIFSFileSystem fs=newPOIFSFileSystem(new FileInputStream("d:\test.xls"));    
HSSFWorkbook ¡


Ïà¹ØÎĵµ£º

ÓÃJavaʵÏÖÎļþ·Ö¸î\ºÏ²¢²Ù×÷

import java.io.File;
import java.io.FilenameFilter;
import java.io.IOException;
import java.io.RandomAccessFile;
import java.sql.Timestamp;
import java.util.Arrays;
public class SmallToBig {
 private String newFileName;// ÐÂÎļþÃû×Ö
 private String filterName;// ¹ýÂ˹æÔòÃû×Ö
  ......

JAVA¶ÔÏóת»»ÎªXML¸ñʽ

JAVA¶ÔÏóת»»ÎªXML¸ñʽ
    ¼òµ¥µÄ²üÊöÏÂÈçºÎ½«JAVA¶ÔÏóת»»ÎªXML¸ñʽ£¬ÏêϸÁ˽âÇë½øÈëhttp://xstream.codehaus.org/tutorial.html
  
 JAVABEAN¶ÔÏó
 
  userInfo.java
         private String name;
   & ......

JavaµÄmain·½·¨ÓëÀàµÄ¼ÓÔØµÄÁªÏµ

¼øÓÚÐí¶àͬѧ¶ÔÕâ¸ömain·½·¨µÄÃÔ»ó£¡ÎÒÕâÀïÌṩһЩÒâ¼û£¬Ï£Íû¶Ô´ó¼ÒÓаïÖú£¡ºÇºÇ£¡
     ****ÎÒÃÇ˵¼ÓÔØÏÈ£º
      JavaµÄÀàÊÇÓõ½²Å¿ªÊ¼¼ÓÔØµÄ£¬²¢ÇÒÔÚÿ¸öÀàµÄ¹¹ÔìÆ÷µ÷ÓÃ֮ǰ£¬ÀàµÄÿ¸öÓò£¨³ÉÔ±±äÁ¿£©¶¼ÒªÊ×Ïȱ»±àÒëÆ÷³õʼ»¯Ò»´Î£¬È»ºó²ÅÂÖµ½¹¹ÔìÆ÷À´¸É»î¶ù¡£µ«ÊÇ£¬Java ......

java³ÌÐò~ÌìÊý


//ÊäÈëijÄêijÔÂijÌ죬Êä³öÕâÒ»ÌìÊÇÕâÒ»ÄêµÄµÚ¼¸Ìì
public class DaySum {
 public static void main(String[] args)
 {
  date da=new date();
  System.out.println(da.count(2008,12,31));
 }
 
}
class date
{
 int count(int  year,int month,int day) ......

ÉîÈëdz³öJavaÉè¼ÆÄ£Ê½Ö®ÊÊÅäÆ÷ģʽ


ͨ³££¬¿Í»§Àà(clients of class)ͨ¹ýÀàµÄ½Ó¿Ú·ÃÎÊËüÌṩµÄ·þÎñ¡£ÓÐʱ£¬ÏÖÓеÄÀà(existing class)¿ÉÒÔÌṩ¿Í»§ÀàµÄ¹¦ÄÜÐèÒª£¬µ«ÊÇËüËùÌṩµÄ½Ó¿Ú²»Ò»¶¨Êǿͻ§ÀàËùÆÚÍûµÄ¡£ÕâÊÇÓÉÓÚÏÖÓеĽӿÚÌ«Ïêϸ»òÕßȱ·¦Ïêϸ»ò½Ó¿ÚµÄÃû³ÆÓë¿Í»§ÀàËù²éÕҵIJ»Í¬µÈÖî¶à²»Í¬Ô­Òòµ¼Öµġ£
¡¡¡¡ÔÚÕâÖÖÇé¿öÏ£¬ÏÖÓеĽӿÚÐèҪת»¯(convert)Ϊ¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ