+6 votes
738 views
in Programming by Expert (3.8k points)

i am using a array and with a loop aading the items in array like this :

public ArrayList<String> Items(){
    ArrayList<String> objItemList = new ArrayList<String>();
    Sheet objSheet = this.objExcel.getSheet("path");
    for(int i=1;i <= objSheet.getRows();i++){
        
        objItemList.add("A"+i);
        
   }

}

but getting this exception

java.lang.ArrayIndexOutOfBoundsException: 7

Thanks For help!

closed

1 Answer

+1 vote
by Expert (5.9k points)
selected by
 
Best answer
Give row count with -1 in loop like this

  for(int i=1;i <= objSheet.getRows()-1;i++){
        
        objItemList.add("A"+i);
        
       }

So your code will be

public ArrayList<String> Items(){
ArrayList<String> objItemList = new ArrayList<String>();
 Sheet objSheet = this.objExcel.getSheet("path");
 for(int i=1;i <= objSheet.getRows()-1;i++){
        
        objItemList.add("A"+i);
        
            }

            }

This will help you out if you face any problem let me know!

Not a Member yet?

Ask to Folks Login

My Account

Your feedback is highly appreciated