사용환경은 android eclipse 입니다. <div><br></div> <div>우선 코드 적으면</div> <div><font color="#7f7f7f"><br></font></div> <div><div><font color="#7f7f7f">public void readExcel(Context context)</font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>{</font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>try</font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>{</font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>InputStream dbInputStream = context.getAssets().open("hospital.xls", Context.MODE_WORLD_READABLE);</font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>Workbook workbook = Workbook.getWorkbook(dbInputStream);</font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>Sheet sheet=workbook.getSheet(0);</font></div> <div><span class="Apple-tab-span" style="white-space:pre;"><font color="#7f7f7f"> </font></span></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>int rowLength = sheet.getRows();</font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>int columnLength=sheet.getColumns();</font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>Log.e("row : " , ""+rowLength);</font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>Log.e("Colum : ", ""+columnLength);</font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span></font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>String[][]data=new String[rowLength][columnLength];</font></div> <div><span class="Apple-tab-span" style="white-space:pre;"><font color="#7f7f7f"> </font></span></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>for(int i = 0; i<rowLength ; i++)</font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>{</font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>for(int j =0; j<columnLength; j++)</font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>{</font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>Cell cell = sheet.getCell(i,j);</font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>data[i][j]=cell.getContents();</font></div> <div><span class="Apple-tab-span" style="white-space:pre;"><font color="#7f7f7f"> </font></span></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>Log.e("cell["+i+"]["+j+"]", ""+cell);</font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>Log.e("data["+i+"]["+j+"]", ""+data[i][j]);</font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>}</font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>}</font></div> <div><span class="Apple-tab-span" style="white-space:pre;"><font color="#7f7f7f"> </font></span></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>Log.e("row : " , ""+rowLength);</font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>Log.e("Colum : ", ""+columnLength);</font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>}</font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>catch(Exception e )</font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>{</font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>Log.e("exception error : ", ""+e);</font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>}</font></div> <div><span class="Apple-tab-span" style="white-space:pre;"><font color="#7f7f7f"> </font></span></div> <div><font color="#7f7f7f"><br></font></div> <div><font color="#7f7f7f"><span class="Apple-tab-span" style="white-space:pre;"> </span>}</font></div></div> <div><br></div> <div>입니다.</div> <div>log를 통해 row와 column 을 살펴보면 </div> <div>row : 84 , column : 15 입니다.</div> <div><font color="#7f7f7f"><br></font></div> <div>나오는 에러메세지는</div> <div>java.lang.ArrayIndexOutOfBoundsException: length=15; index=15</div> <div><br></div> <div>인데요..</div> <div><br></div> <div>column 수에따라서 뒤에 에레메세지가 변경됩니다.</div> <div>예를들어 column 을 7로 조정하면</div> <div><span style="line-height:14.4px;">java.lang.ArrayIndexOutOfBoundsException: length=7; index=7</span></div> <div>로 에러메세지가 출력됩니다..</div> <div><br></div> <div>뭐가 문제일까요 ..? 조언부탁드립니다.ㅠㅠ</div> <div>감사합니다 </div> <div><br></div>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.