public static void readExls(String filePathName) throws BiffException, IOException
{
//File file=new File(filePathName);
InputStream is = new FileInputStream(filePathName);
//首先获得当前的exls文件
Workbook workbook=Workbook.getWorkbook(is);
//获取所有的工作报表
Sheet[]allSheet= workbook.getSheets();
//循环单个工作报表
for (int i = 0; i < allSheet.length; i++) {
Sheet tempSheet=allSheet[i];
System.out.println("表格名"+tempSheet.getName());
System.out.println(tempSheet.getRows()
);
}
}表格名Sheet1
Warning: Cannot read drop down range Unrecognized token 43
Exception in thread "main" java.lang.NullPointerException
at jxl.biff.DataValiditySettingsRecord.getFirstColumn(DataValiditySettingsRecord.java:237)
at jxl.read.biff.SheetReader.read(SheetReader.java:925)
at jxl.read.biff.SheetImpl.readSheet(SheetImpl.java:657)
at jxl.read.biff.SheetImpl.getRows(SheetImpl.java:412)
at com.qun.handle.ReadExls.readExls(ReadExls.java:29)
at com.qun.handle.Test.main(Test.java:16)
你这个问题用debug来调试一下就出来了啊! 自己学会解决BUG啊!
不过我已经读取出来的
WorkBookSetting设定一下disableVlidate(true)再实例化Workbook类就