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

java¶ÁÈ¡±¾µØexcelÎļþ´úÂë

package cn.com.view.read;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
public class ReadExcel {
 
 public static void main(String[] args){
  read("d://air.xls");
 }
 
 public static Cell[][] read(String fileName){
  Workbook rwb = null;
  InputStream is;
  try {
   is = new FileInputStream(fileName);
   rwb = Workbook.getWorkbook(is);
   
  } catch (FileNotFoundException e) {
   e.printStackTrace();
  } catch (BiffException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (IOException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  int sheets = rwb.getNumberOfSheets();
  Sheet rs = rwb.getSheet(0);
  String sheetName = rs.getName();//»ñÈ¡SheetµÄÃû³Æ
  int rsColumns = rs.getColumns();//»ñÈ¡Sheet±íÖÐËù°üº¬µÄ×ÜÁÐÊý
  Cell[] cellCol = rs.getColumn(1);  //»ñȡijһÁеÄËùÓе¥Ôª¸ñ£¬·µ»ØµÄÊǵ¥Ôª¸ñ¶ÔÏóÊý×é
  int rsRows = rs.getRows();  //»ñÈ¡Sheet±íÖÐËù°üº¬µÄ×ÜÐÐÊý
  Cell[] cellRow = rs.getRow(1); //»ñȡijһÐеÄËùÓе¥Ôª¸ñ£¬·µ»ØµÄÊǵ¥Ôª¸ñ¶ÔÏóÊý×é
//  Cell cell = rs.getCell(0, 0); //µÚÒ»¸öÊÇÁÐÊý£¬µÚ¶þ¸öÊÇÐÐÊý
  System.out.println("SheetµÄ¸öÊý£º"+sheets);
  System.out.println("SheetµÄÃû³Æ£º"+sheetName);
  System.out.println("ÁÐÊý£º"+rsColumns);
  System.out.println("ÐÐÊý£º"+rsRows);
 /* for(int i = 0;i < cellCol.length;i++){
   System.out.println("µÚÒ»ÁÐ×ֶΣº"+cellCol[i].getContents());
  


Ïà¹ØÎĵµ£º

ÔÚjavaÖÐʹÓÃίÍÐʵÏÖmap/filter

ÔÚjavaÖУ¬¼ÙÉèÄãÓÐÒ»¸öuser ¶ÔÏóµÄlist£¬´Ëuser¶ÔÏó·â×°ÁËÓû§µÄid, first name, last name and age. È»ºóÄãÏëµ÷ÓÃÒ»¸öweb service(eg. UserService.deleteUsersByIds(List<Integer> userIds) ȥɾ³ýÊý¾Ý¿âÖÐÖ¸¶¨µÄÕâЩuser¡£  ÌýÆðÀ´Ëƺõ²»Ì«À§ÄÑ£¬²»ÊÇô? ÄãËùÐèÒªÖ»Êǽ« List<User> ת»¯³ÉList&l ......

[±¸·Ý]javaÖÐXML½âÎöÀûÆ÷ dom4jµÄʹÓüò½é


ҪʹÓÃdom4j¶ÁдXMLÎĵµ,ÐèÒªÏÈÏÂÔØdom4j°ü,dom4j¹Ù·½ÍøÕ¾ÔÚ http://www.dom4j.org/
Ŀǰ×îÐÂdom4j°üÏÂÔØµØÖ·: http://nchc.dl.sourceforge.net/sourceforge/dom4j/dom4j-1.6.1.zip
½â¿ªºóÓÐÁ½¸ö°ü,½ö²Ù×÷XMLÎĵµµÄ»°°Ñdom4j-1.6.1.jar¼ÓÈ빤³Ì¾Í¿ÉÒÔÁË,Èç¹ûÐèҪʹÓÃXPathµÄ»°»¹ÐèÒª¼ÓÈë°üjaxen-1.1-beta-7.jar.
ÒÔÏÂ ......

javaÉú³ÉEXCEL±í¸ñ£¨POI vs JXL£©

javaÉú³Éexcel±í¸ñ£¬ÒÔǰֻ֪µÀPOI£¬ÕâÊÇApacheµÄ¿ªÔ´ÏîÄ¿£¬±¾À´ÊÇÒ»Ì׵쬰üÀ¨word£¬µ«ÊÇÒòΪwordµÄ¸´ÔÓÐÔ£¬ÒÔ¼°¿ª·¢ÈËÔ±µÄȱ·¦£¬ºÃÏñ»ù±¾Í£ÖÍÁË¡£Ö»ÓÐExcel×öµÄ»¹Ëã±È½ÏÍêÕû£¬ÓÃÆðÀ´±È½ÏÇáËÉ¡£
    ºóÀ´ÒòΪ×öÏîÄ¿µÄ¹ØÏµ£¬ÖªµÀÁË»¹ÓиöJXL£¨java excel£©£¬Ò²ÊǸö¿ªÔ´ÏîÄ¿£¬ÓÃÆðÀ´µÄ¸Ð¾õ¸úPOIºÜÀàËÆ£¬ÒòΪ ......

JAVA JNI

http://blog.csdn.net/hbcui1984/archive/2009/12/10/4980805.aspx
Ò»¡¢¸ÅÊö
JNI(java native interface)£¬JAVA±¾µØ½Ó¿Úµ÷Óã¬Ä¿µÄÊÇΪÁËJAVA¿ÉÒÔµ÷Óñ¾µØ³ÌÐò£¬Ö÷ÒªÓŵãÓУº
Ìá¸ßЧÂÊ£¬½â¾öÐÔÄÜÎÊÌâ
·ÀÖ¹·´±àÒ룬Ìá¸ßºËÐÄ´úÂ밲ȫÐÔ
ÔöÇ¿±¾»ú½Ó¿Úµ÷ÓÃ
ǶÈëʽ¿ª·¢Ó¦ÓÃ
    ÈçÏÂͨ¹ýÒ»¸ö×î¼òµ¥µÄÐ ......

JavaÀûÓÃxml½«´óÅúÁ¿Êý¾Ýµ¼³öµ½excelµÄÒ»¸ö·½·¨

±ÊÕßÔÚJava¿ª·¢Öг£³£»áÓöµ½½«Êý¾Ý¿âÊý¾Ýµ¼³öµ½ExcelµÄÒªÇ󣬱ÈÈçÔÚÎÒµÄÒ»¸öÏîÄ¿ÖУ¬¿Í»§ÒªÇóËùÓвéѯ½á¹û¶¼¿ÉÒÔµ¼³öµ½Excel£¬¶ÔÓÚÊý¾ÝÁ¿²»´óµÄ£¨¼¸ÍòÌõ£©£¬Õâ±È½ÏÈÝÒ×ʵÏÖ£¬µ«¶ÔÓÚÊý¾ÝÁ¿±È½Ï´óµÄ£¨¼¸Ê®Íò¼°ÒÔÉÏ£¬¾ßÌåÒª¿´µ¼³öÄÚÈݵÄ×ֶθöÊýºÍ³¤¶Ì£©£¬ÔòÔÚÊý¾Ý¿â²éѯºÍÉú³ÉexcelÎļþÉ϶¼»áÓÐÂé·³¡£
ÒÔÎÒÔÚʵ¼ÊÏîÄ¿ÖеÄÒ»¸ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ