問題：
使用了兩種方式讀取excel，執行都報錯：jxl.read.biff.BiffException: Unable to recognize OLE stream
以下代碼片段：
package com.hlq.atm.excelCase;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
public class ExcelReadWrite {
public static void main(String[] args) {
ExcelReadWrite erw=new ExcelReadWrite();
String path=System.getProperty("user.dir");
// erw.readExcelByJxl(path+"/data/Students.xls");
erw.re(path+"/data/Students.xls");
}
public void re(String pathName) {
try {
//創建workbook
Workbook workbook=Workbook.getWorkbook(new File(pathName));
//獲取第一個作業表sheet
Sheet sheet=workbook.getSheet(0);
//獲取資料
for (int i=0;i<sheet.getRows();i++){
for (int j=0;j<sheet.getColumns();j++){
Cell cell=sheet.getCell(j,i);
System.out.print(cell.getContents()+" ");
}
System.out.println();
}
workbook.close();
} catch (IOException e) {
e.printStackTrace();
} catch (BiffException e) {
e.printStackTrace();
}
}
public void readExcelByJxl(String fileName) {
File file=new File(fileName);
try {
// FileInputStream fis=new FileInputStream(file);
Workbook workbook=Workbook.getWorkbook(file);
Sheet[] sheet=workbook.getSheets();
for (int i=0;i<sheet.length;i++){
Sheet rs=workbook.getSheet(i);
//遍歷行
for (int j=0;j<rs.getRows();j++){
Cell[] cells=rs.getRow(j);
//遍歷列
for (int z=0;z<cells.length;z++){
System.out.print(cells[z].getContents());
System.out.print("\t");
}
System.out.println();
}
}
workbook.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} catch (BiffException e) {
e.printStackTrace();
}
}
}
原因：
在網上查詢改報錯原因，是檔案版本不兼容，jxl只支持excecl03版
解決辦法：
嘗試另存檔案，選擇Excel 97-2004作業簿，再次執行，執行通過
執行結果：
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/170365.html
標籤：Java
下一篇：switch回圈所支持的資料型別