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Éè¼ÆÄ£Ê½Ö®×ÛÊöƪ
http://tech.it168.com/a2009/0223/266/000000266380.shtml
×Ô´ÓJ2EE³öÏÖÒÔÀ´£¬¾Í´ó´ó¼ò»¯ÁËÔÚJavaÏÂµÄÆóÒµ¼¶¿ª·¢¡£µ«ÊÇËæ×ÅJ2EEÔ½À´Ô½ÆÕ±éµØ±»Ó¦Óõ½¸÷¸öÁìÓòÖУ¬¿ª·¢ÕßÃǽ¥½¥Òâʶµ½ÐèÒªÒ»ÖÖ·½·¨À´±ê×¼»¯Ó¦ÓóÌÐòµÄ¿ª·¢¹ý³Ì£¬ËûÃDzÉÓõķ½·¨ÊDZê×¼»¯Ó¦ÓóÌÐòµÄ½á¹¹²ã¡£Ôڽṹ²ãͨ³£·â×°ÁËһЩ¶ÀÁ¢Ó ......
windows xpÏÂÅäÖÃJDK»·¾³±äÁ¿£º
1.°²×°JDK£¬°²×°¹ý³ÌÖпÉÒÔ×Ô¶¨Ò尲װĿ¼µÈÐÅÏ¢£¬ÀýÈçÎÒÃÇÑ¡Ôñ°²×°Ä¿Â¼ÎªD:\java\jdk1.5.0_08£»
¡¡ 2.°²×°Íê³Éºó£¬ÓÒ»÷“ÎҵĵçÄÔ”£¬µã»÷“ÊôÐÔ”£»
3.Ñ¡Ôñ“¸ß¼¶”Ñ¡Ï£¬µã»÷“ ......
ҪʹÓÃ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С³ÌÐò£¬¾¡¹Ü×îºóûÓÃÉÏ£¬µ«ÊÇ×÷ΪÁ·Ï°»¹ÊDz»´íµÄ¡£
ÐèÇ󣺶ÔÓÚÏñÈçϵÄ×Ö·û´´½«Æä·Ö¸ôΪÁ½ÁУ¬ÕâÑù¾Í¿ÉÒÔÖ±½ÓÕ³ÌùµÄExcelÖи÷×ÔÁУ¬·ñÔòÒ»¸öÒ»¸ö·Ö¸ô»áºÄ·ÑºÜ¶àʱ¼ä¡£
16 bit microcomputer 16 λ΢ÐͼÆËã»ú
3 d distribution Èýά·Ö²¼
4 ......