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

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


Ïà¹ØÎĵµ£º

javaÉú³ÉËæ»úÊý×ÖºÍ×Öĸ×éºÏ


×¢£º1.·½·¨µÄ²ÎÊý length ÊÇÉú³ÉµÄËæ»úÊýµÄ³¤¶È¡£
      2. Ö»ÏëÒª´óдµÄ×Öĸ ¿ÉÒÔʹ int choice =65£» Ö»ÏëҪСдµÄ×Öĸ£¬¾Í int choice =97£»
import java.util.Random;
public String getCharAndNumr(int length)  
{  
    String val = " ......

Ãô½Ý¿ª·¢Öбàд¸ßÖÊÁ¿Java´úÂë

Ãô½Ý¿ª·¢Öбàд¸ßÖÊÁ¿Java´úÂë
2010-03-08 10:32
 | 
1709
´ÎÔĶÁ
 | 
¡¾ÒÑÓÐ9
ÌõÆÀÂÛ¡¿·¢±íÆÀÂÛ
À´Ô´£º±ÈÌØÍø À´Ô´£ºIBM/ÍõÓÀ¿ý
 | 
Êղص½ÎÒµÄÍøÕª
Ãô½Ý¿ª·¢µÄÀíÄîÒѾ­Á÷ÐÐÁ˺ܳ¤µÄʱ¼ä£¬ÔÚÃô½Ý¿ª·¢ÖеĿª·¢µü´ú½×¶ÎÖУ¬ÎÒÃÇ¿ÉÒÔͨ¹ýÎå¸ö²½Ö裬À´ÓÐЧµÄÌá¸ßÕû¸öÏîÄ¿µÄ´úÂëÖÊÁ¿¡ ......

Java±àÂë¹æ·¶£¨The Elements of Java Style£©

Genaral Principles Ò»°ãÔ¼¶¨
1.Adhere to the style
of the original.
±£³Ö×î³õµÄÑùʽ¡£
2.Adhere to the Principle of Least
Astonishment.
×ñÊØ×îС¾ªÆæÔ­Ôò¡£
3.Do it right the first time.

µÚÒ»´Î¾ÍÓ¦µ±×öºÃ¡£
4.Document any deviations.
¶ÔÓÚÈκα³Àë¶¼Ó¦µ±Îĵµ×¢ÊÍ¡£
Formatting
Convent ......

Ãô½Ý¿ª·¢Öбàд¸ßÖÊÁ¿Java´úÂë

Ô­Îijö´¦£ºhttp://java.csdn.net/a/20100308/259219.html
Ãô½Ý¿ª·¢µÄÀíÄîÒѾ­Á÷ÐÐÁ˺ܳ¤µÄʱ¼ä£¬ÔÚÃô½Ý¿ª·¢ÖеĿª·¢µü´ú½×¶ÎÖУ¬ÎÒÃÇ¿ÉÒÔͨ¹ýÎå¸ö²½Ö裬À´ÓÐЧµÄÌá¸ßÕû¸öÏîÄ¿µÄ´úÂëÖÊÁ¿¡£
JavaÏîÄ¿¿ª·¢¹ý³ÌÖУ¬ÓÉÓÚ¿ª·¢ÈËÔ±µÄ¾­Ñé¡¢Java´úÂë±àдϰ¹ß£¬ÒÔ¼°È±·¦Í³Ò»µÄ±ê×¼ºÍ¹ÜÀíÁ÷³Ì£¬ÍùÍùµ¼ÖÂÕû¸öÏîÄ¿µÄ´úÂëÖÊÁ¿½Ï²î£¬ÄÑÓ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ