Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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¼ÓÃܺÍÊý×ÖÇ©Ãû±à³Ì¿ìËÙÈëÃÅ

      ±¾ÎÄÖ÷Ҫ̸һÏÂÃÜÂëѧÖеļÓÃܺÍÊý×ÖÇ©Ãû£¬ÒÔ¼°ÆäÔÚjavaÖÐÈçºÎ½øÐÐʹÓ᣶ÔÃÜÂëѧÓÐÐËȤµÄ»ï°é£¬ÍƼö¿´Bruce SchneierµÄÖø×÷£ºApplied Crypotography¡£ÔÚjdk1.5µÄ·¢Ðа汾Öа²È«ÐÔ·½ÃæÓÐÁ˺ܴóµÄ¸Ä½ø£¬Ò²ÌṩÁ˶ÔRSAËã·¨µÄÖ±½ÓÖ§³Ö£¬ÏÖÔÚÎÒÃÇ´ÓʵÀýÈëÊÖ½â¾öÎÊÌ⣨±¾ÎĽöÊÇ×÷Ϊ¼òµ¥½éÉÜ£©£º ......

Java»æÍ¼ ÈçºÎÕýÈ·»æÍ¼ºÍ³öÏÖ¹ö¶¯Ìõ

ÃæÊÇÎÒÈÏΪÕýÈ·µÄ×ö·¨£¨½áºÏ×Ô¼ºµÄ¾­ÑéдµÄ£¬Èç¹û²»ÕýÈ·£¬Çë´ó¼ÒÖ¸Õý£©£º
¡¡¡¡ÎҵĻæÍ¼¿Ø¼þÊÇJPanel£¬
¡¡¡¡³öÏÖ¹ö¶¯ÌõµÄǰÌᣬ±ØÐëÈûæÍ¼¿Ø¼þ·ÅÔÚJScrollPaneÉÏ£¬
¡¡¡¡¶ÔÓÚJScrollPaneµÄLayout£¬Ã»ÓÐÌØÊâÒªÇó£¬ÏÂÃæÕâÑù¼´¿É£º
¡¡¡¡view plaincopy to clipboardprint?
¡¡¡¡jScrollPane1.setViewportView(jPanel1);
¡¡ ......

javaÖÐÈçºÎʵÏÖÎļþ´ò°üÉÏ´«ÒÔ¼°×Ô¶¯½âѹ


ÎÒÃÇÔÚ¿ª·¢ÏîÄ¿µÄʱºò,ÌØ±ðÊÇB/Sϵͳ,¾­³£»áÓöµ½ÒªÅúÁ¿ÉÏ´«ÎļþµÄÐèÇó,¶Ô´ËÐèÇóÒ»°ãÓÐÈçϼ¸¸ö½â¾ö·½°¸(ÒÔB/SΪÀý):
1. ÔÚ¿Í»§¶ËÌṩÎļþÉÏ´«½Ó¿Ú,Ò»´ÎÉÏ´«Ò»¸öÎļþ
2. Ò»´ÎÉÏ´«¶à¸öÎļþ
3. ½«ÐèÒªÉÏ´«µÄÎļþ´ò°ü,Ò»´ÎÉÏ´«µ½·þÎñÆ÷,²¢×Ô¶¯½âѹµ½Ö¸¶¨Ä¿Â¼
1,2·½·¨¶¼Óм¸¸öºÜÃ÷ÏԵIJ»×ã,Óû§¹¤×÷Á¿´ó,ÎļþÈç¹û¹ý´ó,ÔÚÍø ......

JavaÔ¶³ÌͨѶ¿ÉÑ¡¼¼Êõ¼°Ô­Àí

ÔÚ·Ö²¼Ê½·þÎñ¿ò¼ÜÖУ¬Ò»¸ö×î»ù´¡µÄÎÊÌâ¾ÍÊÇÔ¶³Ì·þÎñÊÇÔõôͨѶµÄ£¬ÔÚJavaÁìÓòÖÐÓкܶà¿ÉʵÏÖÔ¶³ÌͨѶµÄ¼¼Êõ£¬ÀýÈ磺RMI¡¢MINA¡¢ESB¡¢ Burlap¡¢Hessian¡¢SOAP¡¢EJBºÍJMS µÈ£¬ÕâЩÃû´ÊÖ®¼äµ½µ×ÊÇЩʲô¹ØÏµÄØ£¬ËüÃDZ³ºóµ½µ×ÊÇ»ùÓÚʲôԭÀíʵÏÖµÄÄØ£¬Á˽âÕâЩÊÇʵÏÖ·Ö²¼Ê½·þÎñ¿ò¼ÜµÄ»ù´¡ÖªÊ¶£¬¶øÈç¹ûÔÚÐÔÄÜÉÏÓиߵÄÒªÇóµÄ»°£¬Ä ......

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

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