javaʹÓÃPOI²Ù×÷Excel±¨±í
HSSFWorkbook API£ºhttp://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFWorkbook.html
office°ì¹«Èí¼þµÄʹÓÃʹµÃ¿ª·¢ÆóÒµ°ì¹«ÏµÍ³ÖУ¬³£³£Óпͻ§ÕâÑù×ÓÒªÇó£ºÄãÒª°ÑÎÒÃǵı¨±íÖ±½ÓÓÃExcel´ò¿ª¡£»òÕßÊÇ£ºÎÒÃÇÒѾϰ¹ßÓÃExcel´òÓ¡¡£ÕâÑù×ÓÈç¹ûÓÃ.net¿ª·¢ÊÇûÓÐÎÊÌâµÄ£¬µ«ÊÇÓÐj2eeÕâ¸ö±È.net¸üÓÐǰ;µÄ¿ª·ÅʽµÄ¿ª·¢»·¾³£¬ÄѵÀÎÒΪÁ˽â¾ö´òÓ¡µÄÒªÇóÈ¥Áíд¿Í»§¶ËµÄ¿Ø¼þ£¿»òÕßÔÚ·þÎñÆ÷¶ËʹÓñ¾µØ´úÂ룿µÚÒ»ÖÖ·½°¸µÄÎÊÌâÊǹؼüÊý¾ÝµÄ´¦ÀíÓÐʱºò²»ÄÜÔÚ¿Í»§¶Ë×ö£¬µÚ2ÖÖ·½°¸µÄÎÊÌâÊÇÎþÉüÁË´úÂëµÄ¿ÉÒÆÖ²ÐÔºÍÎȶ¨ÐÔ¡£
ApacheµÄJakataÏîÄ¿µÄPOI×ÓÏîÄ¿£¬Ä¿±êÊÇ´¦Àíole2¶ÔÏó¡£Ä¿Ç°±È½Ï³ÉÊìµÄÊÇHSSF½Ó¿Ú£¬´¦ÀíMS Excel£¨97-2002£©¶ÔÏó¡£ËûÊÇÕæÕýµÄExcel¶ÔÏ󣬿ÉÒÔ¿ØÖÆÒ»Ð©ÊôÐÔÈçsheet,cellµÈµÈ¡£ÏÖÔÚHSSFÒѾ³ÉÊìµ½Äܹ»ºÍ×ã¹»ÎÒÃÇʹÓÃÁË
POI¿ÉÒÔµ½www.apache.orgÏÂÔØµ½¡£±àÒëºÃµÄjarÖ÷ÒªÓÐÕâÑù4¸ö£ºpoi°ü,poi Browser°ü,poi hdf°ü,poi hssfÀý³Ì°ü¡£Êµ¼ÊÔËÐÐʱ£¬ÐèÒªÓÐpoi°ü¾Í¿ÉÒÔÁË¡£
hssfµÄ¸÷ÖÖ¶ÔÏó¶¼ÓÐÀý³ÌµÄ½éÉÜ¡£hssfÌṩµÄÀý³ÌÔÚorg.apache.poi.hssf.usermodel.examples°üÖУ¬¹²ÓÐ14¸ö£¬Éú³ÉµÄÄ¿±êxls¶¼ÊÇworkbook.xls¡£
Èç¹ûÄãÏë¿´¸ü¶àµÄÀý³Ì£¬¿ÉÒԲο¼hssfµÄJunit test cases£¬ÔÚpoiµÄ°üµÄÔ´´úÂëÖÐÓС£hssf¶¼ÓвâÊÔ´úÂë¡£
ÄÇôJavaÊÇÔõôÑùʹÓÃPOI°ü²Ù×÷excelµÄ£¿
1¡£Ê×ÏÈÏÂÔØµ½http://www.apache.org/ÏÂÔØpoi£¬ÔÚ¹¤³ÌÖÐÒýÈëÈ»ºó£º
ÔÚservletÀïÃæµÄdoGet·½·¨Ð´·¨ÈçÏ£º
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import java.io.*;
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//ÉèÖ÷µ»ØÊý¾ÝÀàÐÍ
response.setContentType("application/vnd.ms-excel;charset=GBK");
//ÉèÖ÷µ»ØµÄÎļþÃû
response.setHeader("Content-Disposition",
"attachment;Filename=Excel.xls");
//µÃµ½Êä³öÁ÷
OutputStream outStream = response.getOutputStream();
//н¨Ò»¸ö¹¤×÷±¡
HSSFWorkbook wb = new HSSFWorkbook();
//½¨Ò»¸ö²åÒ³
HSSFSheet sheet = wb.createSheet("new sheet");
//²åÈë¶àÐУ¬²¢¼ÓÈëÊý¾Ý
for(int i=0;i<10;i++){
HSSFRow rowi = sheet.createRo
Ïà¹ØÎĵµ£º
×¢£º1.·½·¨µÄ²ÎÊý length ÊÇÉú³ÉµÄËæ»úÊýµÄ³¤¶È¡£
2. Ö»ÏëÒª´óдµÄ×Öĸ ¿ÉÒÔʹ int choice =65£» Ö»ÏëҪСдµÄ×Öĸ£¬¾Í int choice =97£»
import java.util.Random;
public String getCharAndNumr(int length)
{
String val = " ......
JavaÓïÑÔÌØ±ðÇ¿µ÷׼ȷÐÔ£¬µ«¿É¿¿µÄÐÐΪҪÒÔÐÔÄÜ×÷Ϊ´ú¼Û¡£ÕâÒ»ÌØµã·´Ó³ÔÚ×Ô¶¯ÊÕ¼¯À¬»ø¡¢ÑϸñµÄÔËÐÐÆÚ¼ì²é¡¢ÍêÕûµÄ×Ö½ÚÂë¼ì²éÒÔ¼°±£ÊصÄÔËÐÐÆÚͬ²½µÈµÈ·½Ãæ¡£¶ÔÒ»¸ö½âÊÍÐ͵ÄÐéÄâ»úÀ´Ëµ£¬ÓÉÓÚĿǰÓдóÁ¿Æ½Ì¨¿É¹©ÌôÑ¡£¬ËùÒÔ½øÒ»²½×è°ÁËÐÔÄܵķ¢»Ó¡£
“ÏÈ×öÍêËü£¬ÔÙÖð²½ÍêÉÆ¡£ÐÒºÃÐèÒª¸Ä½øµÄµØ·½Í¨³£²»»áÌ«¶à¡£”£¨ ......
// messages.hello.properties
id=001
name=ϧԵ
love=I think,therefor i am.
friends=Hi! {0} and {1} ,how are you?
// org.PropertiesUtil.java
package org;
import java.io.UnsupportedEncodingException;
import java.text.MessageFormat;
import java.util.Locale;
import java.util.MissingResourceEx ......
//ÅÅÐòºÍ²éÕÒÊÇÊý¾Ý½á¹¹ÓëËã·¨Éè¼ÆµÄÖØÒªÄÚÈÝ
/*
ÅÅÐòÖ÷Òª°üÀ¨
1.²åÈëÅÅÐò£ºÓÖ°üÀ¨Ö±½Ó²åÈëÅÅÐò¡¢¶þ·Ö·¨²åÈëÅÅÐò¡¢±í²åÈëÅÅÐò¡¢ShellÅÅÐò
2.Ñ¡ÔñÅÅÐò£º°üÀ¨Ö±½ÓÑ¡ÔñÅÅÐò¡¢¶ÑÅÅÐò
3.½»»»ÅÅÐò£ºÃ°ÅÝÅÅÐò¡¢¿ìËÙÅÅÐò
4.·ÖÅäÅÅÐò£ºÖ÷ÒªÓлùÊýÅÅÐò
5.¹é²¢ÅÅÐò£ºÖ÷ÒªÓÐÄÚÅÅÐò¡¢ÍâÅÅÐò
×¢£ºÒÔϳÌÐò¾ùÔÚ±¾È˵çÄÔÉÏͨ¹ýÍêÕ ......