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

apache.org | 1 week ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    POI regression testing report

    apache.org | 1 week 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