java.lang.IllegalArgumentException: Sheet index (18) is out of range (0..17)

Stack Overflow | Kaustav Basu | 10 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    XSSFSheet: Sheet index is out of range

    Stack Overflow | 10 months ago | Kaustav Basu
    java.lang.IllegalArgumentException: Sheet index (18) is out of range (0..17)
  2. 0

    Read from excel cell Eclipse

    Stack Overflow | 2 years ago | Pepiii
    java.lang.IllegalArgumentException: Sheet index (1) is out of range (0..-1)
  3. 0

    Write data into new row in excel file whenever i run the code using Apache POI in Selenium WebDriver

    Stack Overflow | 10 months ago | user2526830
    java.lang.IllegalArgumentException: Sheet index (0) is out of range (no sheets)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  1. Casper 1 times, last 2 weeks ago
1 unregistered visitors

Root Cause Analysis

  1. java.lang.IllegalArgumentException

    Sheet index (18) is out of range (0..17)

    at org.apache.poi.xssf.usermodel.XSSFWorkbook.validateSheetIndex()
  2. Apache POI
    XSSFWorkbook.getSheetAt
    1. org.apache.poi.xssf.usermodel.XSSFWorkbook.validateSheetIndex(XSSFWorkbook.java:1205)
    2. org.apache.poi.xssf.usermodel.XSSFWorkbook.getSheetAt(XSSFWorkbook.java:960)
    2 frames
  3. BasicCoreFramework
    ObjectUtilities.ConvertToCSVOrgtoOrg
    1. BasicCoreFramework.ObjectUtilities.ConvertToCSVOrgtoOrg(ObjectUtilities.java:1625)
    1 frame
  4. TestUtilities
    FileManipulation.PostAggregationScenario1Functionality
    1. TestUtilities.FileManipulation.PostAggregationScenario1Functionality(FileManipulation.java:40)
    1 frame
  5. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    4. java.lang.reflect.Method.invoke(Unknown Source)
    4 frames
  6. TestNG
    RemoteTestNG.main
    1. org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:85)
    2. org.testng.internal.Invoker.invokeMethod(Invoker.java:639)
    3. org.testng.internal.Invoker.invokeTestMethod(Invoker.java:816)
    4. org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1124)
    5. org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:125)
    6. org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:108)
    7. org.testng.TestRunner.privateRun(TestRunner.java:774)
    8. org.testng.TestRunner.run(TestRunner.java:624)
    9. org.testng.SuiteRunner.runTest(SuiteRunner.java:359)
    10. org.testng.SuiteRunner.runSequentially(SuiteRunner.java:354)
    11. org.testng.SuiteRunner.privateRun(SuiteRunner.java:312)
    12. org.testng.SuiteRunner.run(SuiteRunner.java:261)
    13. org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
    14. org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86)
    15. org.testng.TestNG.runSuitesSequentially(TestNG.java:1215)
    16. org.testng.TestNG.runSuitesLocally(TestNG.java:1140)
    17. org.testng.TestNG.run(TestNG.java:1048)
    18. org.testng.remote.AbstractRemoteTestNG.run(AbstractRemoteTestNG.java:126)
    19. org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:137)
    20. org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:58)
    20 frames