public void GetExcelInfos(){
Workbook rwb = null;
try {
rwb = Workbook.getWorkbook(new File("D:/country.xls"));
//获得工作薄的个数
rwb.getNumberOfSheets();
//在Excel文档中,第一张工作表的缺省索引是0
Sheet st = rwb.getSheet(0);
//通用的获取cell值的方式,getCell(int column, int row) 行和列
int rows=st.getRows();
int cols=st.getColumns();
System.out.println("当前工作表的名字:"+st.getName());
System.out.println("总行数:"+rows);
System.out.println("总列数:"+cols);
for(int i=0 ; i < rows ; i ++){
Cell c1=st.getCell(0,i);
Cell c2=st.getCell(1,i);
Cell c3=st.getCell(2,i);
System.out.println("ID: "+c1.getContents()+" EnglishName: "+c2.getContents()+" Cname: "+c3.getContents());
}
} catch (BiffException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
rwb.close();
}
}