参考自：

https://blog.csdn.net/ceovip/article/details/82964487?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159365852719724839247802%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&request_id=159365852719724839247802&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~top_click~default-2-82964487.first_rank_ecpm_v3_pc_rank_v4&utm_term=java%E8%AF%BB%E5%8F%96excel%E8%A1%A8%E6%A0%BC

亲测,OK！

import java.io.*;    

import jxl.*;
import jxl.read.biff.BiffException;
//import jxl.read.biff.*;
public class ReadExcel
{
public static void main(String args[]) throws BiffException, IOException
{
String filepath = "D:\\交叉验证平台\\测试报告\\DRU出厂测试报告8.xls";
File xlsFile = new File(filepath);
// 获得工作簿对象
Workbook workbook = Workbook.getWorkbook(xlsFile);
// 获得所有工作表
Sheet[] sheets = workbook.getSheets();
// 遍历工作表
if (sheets != null)
{
for (Sheet sheet : sheets)
{
// 获得行数
int rows = sheet.getRows();
// 获得列数
int cols = sheet.getColumns();
// 读取数据
for (int row = 0; row < rows; row++)
{
for (int col = 0; col < cols; col++)
{
Cell cell = sheet.getCell(col, row);   
System.out.print(cell.getContents() + " ");   
}
System.out.println();
}
}
}
workbook.close();
}
}

如报错：Exception in thread "main" jxl.read.biff.BiffException:unable to recongnize olestream
降低Excel版本即可，具体参考：https://blog.csdn.net/zhaols11/article/details/22191283?ops_request_misc=&request_id=&biz_id=102&utm_term=java%E8%AF%BB%E5%8F%96excel%E6%97%B6%E6%8A%A5%E9%94%99%EF%BC%9AException%20in%20th&utm_medium=distribute.pc_search_result.none-task-blog-2~all~sobaiduweb~default-0-22191283