Error Executing background job 'Loading Excel File':

dharmender_sing
dharmender_sing New Altair Community Member
edited November 2024 in Community Q&A

I am geeting Error when trying to load Excel data inti Rapidminer Studio 8.2 . 

 

Error Executing background job 'Loading Excel File':
java.lang.classcastException:jxl.biff.drawing.Sp cannot be cast to jxl.biff.drawing.Eschercontainer

 

Detailed Error:- 

 

  • Exception: java.lang.ClassCastException
  • Message: jxl.biff.drawing.Sp cannot be cast to jxl.biff.drawing.EscherContainer
  • Stack trace:
  • jxl.biff.drawing.DrawingData.getSpContainer(DrawingData.java:215)
  • jxl.biff.drawing.Drawing.initialize(Drawing.java:326)
  • jxl.biff.drawing.Drawing.getObjectId(Drawing.java:449)
  • jxl.biff.drawing.DrawingGroup.addDrawing(DrawingGroup.java:212)
  • jxl.biff.drawing.Drawing.(Drawing.java:240)
  • jxl.read.biff.SheetReader.handleObjectRecord(SheetReader.java:1620)
  • jxl.read.biff.SheetReader.read(SheetReader.java:1059)
  • jxl.read.biff.SheetImpl.readSheet(SheetImpl.java:716)
  • jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:257)
  • com.rapidminer.operator.nio.model.ExcelSheetSelection$ByIndex.selectSheetFrom(ExcelSheetSelection.java:109)
  • com.rapidminer.operator.nio.model.ExcelResultSetConfiguration.createExcelTableModel(ExcelResultSetConfiguration.java:213)
  • com.rapidminer.operator.nio.model.ExcelResultSetConfiguration.createExcelTableModel(ExcelResultSetConfiguration.java:181)
  • com.rapidminer.studio.io.data.internal.file.excel.ExcelSheetSelectionPanelModel$1.loadTableModel(ExcelSheetSelectionPanelModel.java:209)
  • com.rapidminer.studio.io.data.internal.file.excel.ExcelSheetSelectionPanelModel$1.run(ExcelSheetSelectionPanelModel.java:173)
  • com.rapidminer.gui.tools.ProgressThread$3.run(ProgressThread.java:550)
  • java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  • java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  • java.lang.Thread.run(Thread.java:748)

Answers

  • Marco_Boeck
    Marco_Boeck New Altair Community Member

    Hi,

     

    Where did you get the Excel file from? Would you happen to be able to send it to me via private message?

     

    Regards,

    Marco

  • Marco_Boeck
    Marco_Boeck New Altair Community Member

    Hi,

     

    for me, the data loads just fine in RapidMiner Studio 8.2.1.

    Is your Studio installation an old one, which you updated frequently? If so, I suspect a broken installation folder. Delete your RapidMiner Studio folder, and install it again via a freshly downloaded installer from our homepage. Your settings won't be affected, as those are stored in your USER_HOME/.RapidMiner folder.

     

     

    Regards,

    Marco

     

  • dharmender_sing
    dharmender_sing New Altair Community Member

    Thanks for looking into the issue 

     

    I have done the same as you recommanded and still facing the same issue. Spreadsheet has two tabs and issue in only with second tab (Data). First tab is fine. 

     

    Thanks & Regards

    Dharmender