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?

       

      Thanks

       

      DW