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

Coderanch | Jil Van Wetter | 3 years 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

    Error: cannot get a numeric value from a text cell

    Coderanch | 3 years ago | Jil Van Wetter
    java.lang.IllegalStateException: Cannot get a numeric value from a text cell
  2. 0

    Java POI - read date from Excel file

    Stack Overflow | 2 years ago | Michael Kuan
    java.lang.IllegalStateException: Cannot get a numeric value from a text cell
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Cannot get a numeric value from a text cell

    Stack Overflow | 7 months ago | meghna
    java.lang.IllegalStateException: Cannot get a numeric value from a text cell

    1 unregistered visitors

    Root Cause Analysis

    1. java.lang.IllegalStateException

      Cannot get a numeric value from a text cell

      at org.apache.poi.xssf.usermodel.XSSFCell.typeMismatch()
    2. Apache POI
      XSSFCell.getNumericCellValue
      1. org.apache.poi.xssf.usermodel.XSSFCell.typeMismatch(XSSFCell.java:845)
      2. org.apache.poi.xssf.usermodel.XSSFCell.getNumericCellValue(XSSFCell.java:208)
      2 frames
    3. Unknown
      ReadTMSData.main
      1. ReadTMSData.main(ReadTMSdata.java:121)
      1 frame