Java读取97-2010 Excel (xls/xlsx) 文件全兼容方法

需要的jar包：poi-3.8-beta2-20110408.jar
             poi-examples-3.8-beta2-20110408.jar
             poi-excelant-3.8-beta2-20110408.jar
             poi-ooxml-3.8-beta2-20110408.jar
             poi-ooxml-schemas-3.8-beta2-20110408.jar
             xmlbeans-2.3.0.jar
             openxml4j-1.0-beta.jar



         /* 
 * Java文件操作 获取文件扩展名 
 * 
 *  Created on: 2011-8-2 
 *      Author: blueeagle 
 */  
    public static String getExtensionName(String filename) {   
        if ((filename != null) && (filename.length() > 0)) {   
            int dot = filename.lastIndexOf('.');   
            if ((dot >-1) && (dot < (filename.length() - 1))) {   
                return filename.substring(dot + 1);   
            }   
        }   
        return filename;   
    }
    /* 
 * Java读取excel 97-2010及以上 
 * 
 *  Created on: 2011-8-2 
 *      Author: blueeagle 

 */ 
    public String readExcel(File file) throws IOException{
     setSavePath("tmp");
String filePath = ServletActionContext.getServletContext().getRealPath(
this.getSavePath())
+ "\\" + getUploadFileName();
     File filepath = new File(filePath);
copy(file, filepath); 
String ExtensionName= getExtensionName(filePath);
System.out.println("后缀名："+ExtensionName);
String value =null;
if(ExtensionName.equals("xls")){
try {
                    System.out.println("2003");
// 创建对Excel工作簿文件的引用
HSSFWorkbook wookbook = new HSSFWorkbook(new FileInputStream(
filePath));
// 在Excel文档中，第一张工作表的缺省索引是0
// 其语句为：HSSFSheet sheet = workbook.getSheetAt(0);
HSSFSheet sheet = wookbook.getSheet("Sheet1");
// 获取到Excel文件中的所有行数-
int rows = sheet.getPhysicalNumberOfRows();
// 遍历行-
for (int i = 0; i < rows; i++) {
// 读取左上端单元格
HSSFRow row = sheet.getRow(i + 1);
// 行不为空
if (row != null) {
// 获取到Excel文件中的所有的列
int cells = row.getPhysicalNumberOfCells();