jxl.read.biff.BiffException #11133 读取excel报出异常. workbook 解析excel 基本代码格式
来源:互联网 发布:欧文季后赛数据 编辑:程序博客网 时间:2024/06/06 01:32
今天遇到Workbook读取excel 时候报出异常:jxl.read.biff.BiffException #11133 .原来是因为excel版本太高,只要把excel另存为Excel 97-2003 的版本就好了。
Workbook 解析excel 的基本程式:
ArrayList list = new ArrayList(); jxl.Workbook workbook = Workbook.getWorkbook(new File("xx/xx/aa.xls")); Sheet[] sheets = workbook.getSheets(); int sheetNum = sheets.length; for (int i=0; i<sheetNum; i++) { Sheet sheet = sheets[i]; TestBean bean = new TestBean(); bean.setSheetName(sheet.getName()); try { int rowNum = sheet.getRows(); int columnNum = sheet.getColumns(); //读取excel是从坐标0,0开始. 0,0代表第一行第一列.前面的代表列,后面的代表行. // SET bean資料 bean.setxxx(this.getCellData(sheet.getCell(0,1)));//读取第2行,第1列中的资料 bean.setxxx(this.getCellData(sheet.getCell(1,1)));//读取第2行,第2列中的资料 }catch(Exception e){ } list.add(bean); }
0 0
- jxl.read.biff.BiffException #11133 读取excel报出异常. workbook 解析excel 基本代码格式
- 使用jxl读取excel报错记录:jxl.read.biff.BiffException: Unable to recognize OLE stream
- java读取Excel 错误: jxl.read.biff.BiffException: Unable to recognize OLE stream
- java读取Excel 错误: jxl.read.biff.BiffException: Unable to recognize OLE stream
- java读取Excel 错误: jxl.read.biff.BiffException: Unable to recognize OLE stream
- java读取Excel 错误: jxl.read.biff.BiffException: Unable to recognize OLE stream
- java读取Excel 错误: jxl.read.biff.BiffException: Unable to recognize OLE stream
- java解析excel文件出错jxl.read.biff.BiffException: Unable to recognize OLE stream
- jxl导入Excel报jxl.read.biff.BiffException: Unable to recognize OLE stream
- 读入Excel报jxl.read.biff.BiffException: Unable to recognize OLE stream
- jxl.read.biff.BiffException: Unable to recognize OLE stream
- unable to load class jxl.read.biff.BiffException
- jxl.read.biff.BiffException: Unable to recognize OLE stream
- jxl.read.biff.biffexception: the input file was not found
- jxl.read.biff.BiffException: Unable to recognize OLE stream
- jxl.read.biff.BiffException: Unable to recognize OLE stream:
- jxl.read.biff.BiffException: Unable to recognize OLE stream解决方法
- jxl.read.biff.biffexception: the input file was not found
- DispatcherServlet作用
- 健忘
- 【UML入门教程】——动态部分(上):状态图、活动图
- 26日上午网易等多家网站无法访问“剖析”
- Struts2做下载
- jxl.read.biff.BiffException #11133 读取excel报出异常. workbook 解析excel 基本代码格式
- 一个完整的802.1X认证的交互
- Android导入项目出现bin/res错误
- <c:if test="${fn:contains(name, searchString)}">
- Android anr异常测试
- org.hibernate.HibernateException: No Session found for current thread
- auto_ptr解析
- NodeJs连接Mysql数据库
- 题目1156:谁是你的潜在朋友