We are building a new experience for our SmartBear Community.
This site is now read-only. You can still browse and search as usual. Learn More

Forum Discussion

Ronald's avatar
Ronald
New Contributor
7 years ago
Solved

java.lang.IndexOutOfBoundsException: Index: 1, Size: 1

I have a Groovyscript to get data from an excel file in a soapui massage.   Groovy script: import com.eviware.soapui.model.*; import com.eviware.soapui.model.testsuite.Assertable; import com....
  • avidCoder's avatar
    avidCoder
    7 years ago

    If you have only sheet available in Excel which is Sheet1. Then, obviously you will get this exception. Please change this to :-

    Sheet sheet = workbook.getSheetAt(0);

    Or if you want to menton the sheet name then use this code:-

    Sheet sheet = workbook.getSheet("Sheet1");

    Hope, this solved your problem.

avidCoder's avatar
avidCoder
Super Contributor
7 years ago

If you have only sheet available in Excel which is Sheet1. Then, obviously you will get this exception. Please change this to :-

Sheet sheet = workbook.getSheetAt(0);

Or if you want to menton the sheet name then use this code:-

Sheet sheet = workbook.getSheet("Sheet1");

Hope, this solved your problem.