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 ¡
Ïà¹ØÎĵµ£º
תÔØ×Ô£ºhttp://blog.csdn.net/seaward/archive/2008/11/26/3376511.aspx
ÓÃgoogleÕÒµ½¹ýÀÏÍâдµÄÏà¹ØµÄÎÄÕ£¬µ«ÊDz»ÍêÕû¡£¸ù¾Ý×Ô¼ºµÄʵ¼ùÖØÐÂдһ¸ö¡£
¼ÙÉ裺ÎÒÃÇÏÖÓÐÒ»¸öjava project½Ð×öoldWebApp£¬Ò»¸öDynamic Web Project½Ð×ödynaWebApp¡£
1¡¢ÔÚoldWebAppµÄ¸ùĿ¼ÏÂÕÒµ½²¢´ò¿ª.projectÎļþ£¬Ð޸ijÉ
<?xml ver ......
¹¹ÔìÆ÷ÊÇΪÁË´´½¨Ò»¸öÀàµÄʵÀý¡£Õâ¸ö¹ý³ÌÒ²¿ÉÒÔÔÚ´´½¨Ò»¸ö¶ÔÏóµÄʱºòÓõ½£ºPlatypus p1 = new Platypus();
¡¡¡¡Ïà·´£¬·½·¨µÄ×÷ÓÃÊÇΪÁËÖ´ÐÐjava´úÂë¡£
¡¡¡¡ÐÞÊηû£¬·µ»ØÖµºÍÃüÃûµÄ²»Í¬
¡¡¡¡¹¹ÔìÆ÷ºÍ·½·¨ÔÚÏÂÃæÈý¸ö·½±ãµÄÇø±ð£ºÐÞÊηû£¬·µ»ØÖµ£¬ÃüÃû¡£ºÍ·½·¨Ò»Ñù£¬¹¹ÔìÆ÷¿ÉÒÔÓÐÈκηÃÎʵÄÐÞÊΣº public, protected ......
import java.util.*;
public class stack
{
private List list=new ArrayList();
private int index=0;
public void push(Object obj)
& ......
ͨ³££¬¿Í»§Àà(clients of class)ͨ¹ýÀàµÄ½Ó¿Ú·ÃÎÊËüÌṩµÄ·þÎñ¡£ÓÐʱ£¬ÏÖÓеÄÀà(existing class)¿ÉÒÔÌṩ¿Í»§ÀàµÄ¹¦ÄÜÐèÒª£¬µ«ÊÇËüËùÌṩµÄ½Ó¿Ú²»Ò»¶¨ÊÇ¿Í»§ÀàËùÆÚÍûµÄ¡£ÕâÊÇÓÉÓÚÏÖÓеĽӿÚÌ«Ïêϸ»òÕßȱ·¦Ïêϸ»ò½Ó¿ÚµÄÃû³ÆÓë¿Í»§ÀàËù²éÕҵIJ»Í¬µÈÖî¶à²»Í¬ÔÒòµ¼Öµġ£
¡¡¡¡ÔÚÕâÖÖÇé¿öÏ£¬ÏÖÓеĽӿÚÐèҪת»¯(convert)Ϊ¿ ......