java 读Excel文档

 一个用POI HSSF access Excel档的例子,poi package可一在http://www.apache.org/dyn/closer.cgi/poi/release/down到,官方网站的说明很详细,

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
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 org.apache.poi.poifs.filesystem.POIFSFileSystem;
public class test{
   public  void readFile(InputStream is){
     //read file
     POIFSFileSystem fs = null;
  try {
   fs = new POIFSFileSystem(is);
  } catch (Exception ex) {
   throw new SystemException("ReadFileException", ex);
  } 
  //make wb
  HSSFWorkbook wb = null;
  try {
   wb = new HSSFWorkbook(fs);
  } catch (IOException ex) {
   ex.printStackTrace();
  }
  //sheet loop
  HSSFSheet sheet = null;
  for(int i=0;i<wb.getNumberOfSheets();i++){
   sheet = wb.getSheetAt(i);
   HSSFRow row = null;
   for(int j=0;j<=sheet.getPhysicalNumberOfRows();j++){
    try{
    row = sheet.getRow(j);
     HSSFCell cell = null;
     cell = row.getCell((short)1);
     System.out.println(getCellValue(cell));

}catch(Exeption e){e.printStackTrace();}
   }}}
 public static void main(String[] args) {
   ().readFile(new FileInputStream(
    "E:/test.xls"));   
 }
}