JAVA读Excel文件的方法

import java.io.File;
import java.util.Date;
import jxl.*;
import jxl.read.biff.*;
import java.io.*;

public class testjeapi {
  public testjeapi() {
    try {
      Workbook workbook = Workbook.getWorkbook(new File("C:/TEMP/ehc.XLS"));
      Sheet sheet = workbook.getSheet(0);
      int rows=sheet.getRows();
      for(int i=1;i<rows;i++){
         String cbxmdm=sheet.getCell(0,i).getContents();
         String cbxmmc=sheet.getCell(1,i).getContents();
      //   String jfsl=sheet.getCell(7,i).getContents().replaceAll(",","");
//System.out.println("jfsl:"+jfsl);
         NumberCell n=(NumberCell)sheet.getCell(7,i);//NumberCell用于读取数字格式的单元格。
         System.out.println("n:"+n.getValue());
         Double d=new Double(n.getValue());
         System.out.println("d:"+d);
        // System.out.println("cell format:"+sheet.getCell(7,i).getType());
//         String jfsl=sheet.getCell(7,i).getContents();
//         String jfje=NumberCell.getCell(8,i).getContents();
//         Double dfsl=new Double(NumberCell.getCell(9,i).getContents());
//         String dfje=sheet.getCell(10,i).getContents();
//         System.out.println(i+"|cbxmdm:"+cbxmdm+"|"+"cbxmmc:"+cbxmmc+"|"+"jfsl:"+jfsl+"|"+"jfje:"+jfje+"|dfsl:"+dfsl+"|dfje:"+dfje);

      }
    }
    catch (BiffException ex) {
      ex.printStackTrace();
    }
    catch (IOException ex) {
      ex.printStackTrace();
    }

  }
  public static void main(String[] args) {
    testjeapi testjeapi1 = new testjeapi();
  }

}