getexcelvalue.java

来自「留学生信息管理系统 我的工程实习的项目」· Java 代码 · 共 43 行

package Xl;

import java.io.FileInputStream;
import java.io.InputStream;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;

public class getExcelValue {

	 public  void x(){
	  try{
	   String sourcefile = "e://j041.xls";
	   InputStream is = new FileInputStream(sourcefile);
	   jxl.Workbook rwb = Workbook.getWorkbook(is);
	   //获得总 Sheets
	   Sheet[] sheets = rwb.getSheets();
	   int sheetLen = sheets.length;
	   for(int i=0;i<sheetLen;i++){
	    //获得单个Sheets 含有的行数
	    jxl.Sheet rs = rwb.getSheet(i); //
	    Cell[] cell_domain = rs.getColumn(0);//读取第一列的值
	    for(int j=1;j<cell_domain.length;j++){
	     System.out.println("Values:"+cell_domain[j].getContents());
	    }    
	   }
	  }catch(Exception ex){
	   ex.printStackTrace();
	  }	  
	 }
	 
	 public String p(){
		 String s=	"happy sunday";
		 return s;
	 }
	 public static void main(String [] args){
		 getExcelValue xl=new getExcelValue() ;
  		 xl.x();
		 
	 }

	  }