java.lang.IllegalStateException: Cannot get a text value from a error cell

Oracle Community | Jackie_C | 4 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Error reading Excel file

    Oracle Community | 4 years ago | Jackie_C
    java.lang.IllegalStateException: Cannot get a text value from a error cell
  2. 0

    Illegal State exception while trying to read an excel file

    Stack Overflow | 3 years ago | hulegukhaan
    java.lang.IllegalStateException: Cannot get a text value from a numeric cell
  3. 0

    reading xlsx example issue

    Coderanch | 5 years ago | sai rama krishna
    java.lang.IllegalStateException: Cannot get a text value from a numeric cell
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JavaXp.com | Java Experts Blog | Java Examples | API | Errors | Exceptions: Java : Read / Write Excel file (.xls or .xlsx) using Apache POI

    javaxp.com | 5 months ago
    java.lang.IllegalStateException: Cannot get a text value from a numeric cell
  6. 0

    Reading xlsx file using Apache POI | Oracle Community

    oracle.com | 1 year ago
    java.lang.IllegalStateException: Cannot get a text value from a numeric cell
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.IllegalStateException

    Cannot get a text value from a error cell

    at org.apache.poi.xssf.usermodel.XSSFCell.typeMismatch()
  2. Apache POI
    XSSFCell.getStringCellValue
    1. org.apache.poi.xssf.usermodel.XSSFCell.typeMismatch(XSSFCell.java:845)
    2. org.apache.poi.xssf.usermodel.XSSFCell.getRichStringCellValue(XSSFCell.java:294)
    3. org.apache.poi.xssf.usermodel.XSSFCell.getStringCellValue(XSSFCell.java:246)
    3 frames
  3. org.jetel.data
    XLSParser.getNext
    1. org.jetel.data.parser.XLSXDataParser.parseNext(XLSXDataParser.java:487)
    2. org.jetel.data.parser.XLSParser.getNext(XLSParser.java:132)
    2 frames
  4. org.jetel.util
    MultiFileReader.getNext
    1. org.jetel.util.MultiFileReader.getNext(MultiFileReader.java:415)
    1 frame
  5. org.jetel.component
    XLSReader.execute
    1. org.jetel.component.XLSReader.execute(XLSReader.java:606)
    1 frame
  6. org.jetel.graph
    Node.run
    1. org.jetel.graph.Node.run(Node.java:414)
    1 frame
  7. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:619)
    1 frame