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 ¡
Ïà¹ØÎĵµ£º
//ÊäÈë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) ......
×î½ü£¬Éî¿ÌµÄÈÏʶµ½£¬ ѧϰ£¬²»½öÒª¶à¿´Ê飬»¹ÒªÊ±²»Ê±µÄ×ܽáһϣº
ÓÃJSP + Servlet + JavaBean¿ª·¢ÏîÄ¿£¬ ÔÒÔΪÊDZȽÏÔã¸âµÄÊ£¬ ÒòΪ£¬JSP Ò³ÃæÖÐ ×ܻᱻǶÈëºÜ¶à java´úÂ룬ÆäʵÎÒÒ»Ö±¾õµÃ£¬¼ÈÈ»ÓÐÁË strutsµÈ±íʾ²ã¿ò¼Ü£¬¾Í²»ÒªÓÃServlet À´×ö¿ØÖÆÆ÷ÁË£¬ ¿ÉÊÇ×î½ü£¬Ã÷°×ÁË£¬ ×Ð ......
½ñÄê3ÔÂAmazon·¢²¼
ÁËеÄJava AWS
SDK
£¬Ö¼ÔÚ¼ò»¯Amazon EC2ÉϵÄJavaÓ¦Óÿª·¢¡£
Amazon EC2ÊǸö˽ÓеÄWeb Services£¬ÌṩÁËÔÆ»·¾³Ïµĵ¯ÐÔ¼ÆËãÄÜÁ¦¡£AWS SDKÖ¼ÔÚ¼ò»¯ÍøÂç¹æÄ££¨web-scale£©ÏµļÆËã¡£AWS Toolkit for
Eclipse
×Ô¶¯»¯ÁË¿ª·¢ÖÜÆÚµÄ´ó¶àÊý²½Ö裬±ÈÈçAmazon¼¯ÈºÉϵIJ¿Êð¡¢µ÷ÊÔ¡¢ÊµÀý¼ÓÔØÒÔ¼°Íø ......
×÷Ϊһ¸öJava³ÌÐòÔ±£¬ÎÒÃdz£³£»áÆÄ¸Ð×ÔºÀµØËµ£º½ðÈÚÐÐÒµµÄ´óϵͳһ°ã¶¼ÊÇÓÃJavaдµÄ¡£ÓÐÌ«¶àÀíÓÉÈÃÎÒÃÇÏàÐÅ£¬JavaÔÚÆóÒµ¼¶Ó¦ÓÃÕâ¿é£¬ÆðמÙ×ãÇáÖØµÄ×÷Óá£È»¶ø£¬ÊÂʵ¹ûÕæÈç´ËÂ𣿽ðÈÚÐÐÒµ»òÐíÊÇÄÇÑù£¬¿ÉÊÇÏñGoogle¡¢AmazonÕâÑùµÄ´óÐÍÍøÕ¾ÄØ£¿Ãæ¶ÔÕâÑùµÄÒÉÎÊ£¬ÔÚ·Ö²¼Ê½Ó¦Óá¢CORBA¡¢JINI¡¢J2EE¡¢Íø¸ñºÍSOAÁìÓò£¬ÓÐ×Å10¶àÄê¾ ......
===================================TimerTask=======================================
import java.util.TimerTask;
import java.util.Calendar;
public class MyTask extends TimerTask
{
private ......