和作者一樣的代碼,導(dǎo)入指定的jar包,但是出現(xiàn)異常,調(diào)試不成功,求指導(dǎo)
做JxlReadExcel練習(xí)的時(shí)候出現(xiàn)解析異常:
異常類(lèi)型java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
開(kāi)發(fā)平臺(tái):win7+MyEclipse2014+jdk1.7
有沒(méi)有大俠幫下?
package?com.imooc.excel; import?java.io.File; import?java.io.IOException; import?jxl.Cell; import?jxl.Sheet; import?jxl.Workbook; import?jxl.write.WritableWorkbook; /** ?*?JXL解析Excel ?* ?*/ public?class?JxlReadExcel?{ ?public?static?void?main(String[]?args)?{ ??File?file?=?new?File("jxl_text.xls"); ???try?{ ????//創(chuàng)建工作薄 ????WritableWorkbook?workbook?= ??????Workbook.createWorkbook(file); ????//獲取第一個(gè)工作表sheet ????Sheet?sheet?=?workbook.getSheet(0); ????//獲取數(shù)據(jù) ????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(); ????} ???}?catch?(Exception?e)?{ ????//?TODO?Auto-generated?catch?block ????e.printStackTrace(); ???} ?} }
2015-04-23
你是想讀取excel文件中的內(nèi)容吧,那不能這么用????
WritableWorkbook?workbook?=??Workbook.createWorkbook(file);
應(yīng)該這么用
Workbook workbook =? Workbook.getWorkbook(file);
2016-07-26
Workbook workbook =? Workbook.getWorkbook(file);
請(qǐng)問(wèn)我的程序這條語(yǔ)句,執(zhí)行到該語(yǔ)句后直接跳到程序的最后,不執(zhí)行該語(yǔ)句的下面的了,請(qǐng)問(wèn)是什么原因