Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÖеÄÕýÔò±í´ïʽ

Ô­ÎĵØÖ·£º http://www.javaworld.com/javaworld/jw-09-2007/jw-09-optimizingregex.html
       
Èç¹ûÄ㻨·ÑÁËÊýСʱºÍÕýÔò±í´ïʽ×ö¶·Õù£¬Ö»ÊÇΪÁËÈÃËüÍê³ÉËü¼¸ÃëÄھͿÉÒÔÍê³ÉµÄÆ¥Å䣬ÄÇôÕâÆªÎÄÕÂÕýÊÇΪÄãÁ¿Éí¶¨×öµÄ¡£Cristian
MocanuÖ¸³öÁËÔÚʲôµØ·½ÕýÔòģʽƥÅä»á·¢ÉúÑÓ³Ù ......

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

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

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

Ãô½Ý¿ª·¢µÄÀíÄîÒѾ­Á÷ÐÐÁ˺ܳ¤µÄʱ¼ä£¬ÔÚÃô½Ý¿ª·¢ÖеĿª·¢µü´ú½×¶ÎÖУ¬ÎÒÃÇ¿ÉÒÔͨ¹ýÎå¸ö²½Ö裬À´ÓÐЧµÄÌá¸ßÕû¸öÏîÄ¿µÄ´úÂëÖÊÁ¿¡£
JavaÏîÄ¿¿ª·¢¹ý³ÌÖУ¬ÓÉÓÚ¿ª·¢ÈËÔ±µÄ¾­Ñé¡¢Java´úÂë±àдϰ¹ß£¬ÒÔ¼°È±·¦Í³Ò»µÄ±ê×¼ºÍ¹ÜÀíÁ÷³Ì£¬ÍùÍùµ¼ÖÂÕû¸öÏîÄ¿µÄ´úÂëÖÊÁ¿½Ï²î£¬ÄÑÓÚά
»¤£¬ÐèÒª½Ï´óµÄ²âÊÔͶÈëºÍÖÜÆÚµÈÎÊÌâ¡£ÕâЩÎÊÌâÔÚÒ»¸ ......

JavaÄÚ²¿ÀàµÄ×÷ÓÃ

Ò»¡¢ ¶¨Òå
·ÅÔÚÒ»¸öÀàµÄÄÚ²¿µÄÀàÎÒÃǾͽÐÄÚ²¿Àà¡£
¶þ¡¢ ×÷ÓÃ
1.ÄÚ²¿Àà¿ÉÒԺܺõÄʵÏÖÒþ²Ø,Ò²¾ÍÊÇ·â×°ÐÔ¡£Ò»°ãµÄ·ÇÄÚ²¿À࣬ÊDz»ÔÊÐíÓÐ private ÓëprotectedȨÏ޵쬵«ÄÚ²¿Àà¿ÉÒÔ
2.ÄÚ²¿ÀàÓµÓÐÍâΧÀàµÄËùÓÐÔªËØµÄ·ÃÎÊȨÏÞ
3.¿ÉÊÇʵÏÖ¶àÖØ¼Ì³Ð
4.¿ÉÒÔ±ÜÃâÐ޸ĽӿڶøÊµÏÖͬһ¸öÀàÖÐÁ½ÖÖͬÃû·½·¨µÄµ÷ÓÃ
 
Èý¡¢  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ