10 Replies Latest reply on Mar 3, 2016 9:32 PM by BKBK

    Cast error trying to read an excel spreadsheet with cfspreadsheet

    dwright65 Level 1

      I'm trying to read an Excel spreadsheet using CF spreadsheet and keep getting the error below.


      java.lang.ClassCastException: org.apache.poi.xssf.usermodel.XSSFRichTextString cannot be cast to org.apache.poi.hssf.usermodel.HSSFRichTextString


      Here is the line of code that causes the error:

      <cfspreadsheet action="read" src = "#xfile#" sheetname="Pilot Instructions" name="pilot_sheet">


      This is CF 11 running in IIS. Any thoughts on why this error is being generated?