java.lang.IllegalArgumentException: Sheet index (20) is out of range (0..19)

apache.org | 4 weeks ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    POI regression testing report

    apache.org | 4 weeks ago
    java.lang.IllegalArgumentException: Sheet index (20) is out of range (0..19)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.lang.IllegalArgumentException

      Sheet index (20) is out of range (0..19)

      at o.a.p.hssf.usermodel.HSSFWorkbook.validateSheetIndex()
    2. o.a.p
      HSSFFileHandler.handleFile
      1. o.a.p.hssf.usermodel.HSSFWorkbook.validateSheetIndex(HSSFWorkbook.java:574)
      2. o.a.p.hssf.usermodel.HSSFWorkbook.getSheetName(HSSFWorkbook.java:726)
      3. o.a.p.hssf.usermodel.HSSFEvaluationWorkbook.getSheetName(HSSFEvaluationWorkbook.java:135)
      4. o.a.p.hssf.usermodel.HSSFEvaluationWorkbook.getExternalSheet(HSSFEvaluationWorkbook.java:165)
      5. o.a.p.ss.formula.ptg.ExternSheetNameResolver.prependSheetName(ExternSheetNameResolver.java:34)
      6. o.a.p.ss.formula.ptg.Ref3DPtg.toFormulaString(Ref3DPtg.java:93)
      7. o.a.p.ss.formula.FormulaRenderer.toFormulaString(FormulaRenderer.java:91)
      8. o.a.p.hssf.model.HSSFFormulaParser.toFormulaString(HSSFFormulaParser.java:119)
      9. o.a.p.hssf.usermodel.HSSFCell.getCellFormula(HSSFCell.java:648)
      10. o.a.p.hssf.usermodel.HSSFCell.toString(HSSFCell.java:1022)
      11. o.a.p.stress.SpreadsheetHandler.readContent(SpreadsheetHandler.java:93)
      12. o.a.p.stress.SpreadsheetHandler.handleWorkbook(SpreadsheetHandler.java:38)
      13. o.a.p.stress.HSSFFileHandler.handleFile(HSSFFileHandler.java:37)
      13 frames
    3. org.dstadler.commoncrawl
      FileHandlingRunnable.run
      1. org.dstadler.commoncrawl.FileHandlingRunnable.run(FileHandlingRunnable.java:64)
      1 frame