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

Coderanch | sai rama krishna | 5 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

    reading xlsx example issue

    Coderanch | 5 years ago | sai rama krishna
    java.lang.IllegalStateException: Cannot get a text value from a numeric 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

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

    javaxp.com | 6 months ago
    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

    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
  6. 0

    Upload and directly parse a file with Spring

    Stack Overflow | 1 year ago | Heady
    java.lang.IllegalStateException: Cannot get a text value from a numeric cell

  1. DoktorDoener666 1 times, last 6 months ago
  2. tyson925 1 times, last 12 months ago
2 unregistered visitors
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 numeric 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. Unknown
    sssssssss.main
    1. sssssssss.ReadSheet(sssssssss.java:60)
    2. sssssssss.main(sssssssss.java:98)
    2 frames