Error Executing background job 'Loading Excel File':

dharmender_singdharmender_sing Member Posts: 2 Contributor I
edited December 2018 in Help

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)
Tagged:

Answers

  • Marco_BoeckMarco_Boeck Administrator, Moderator, Employee, Member, University Professor Posts: 1,993 RM Engineering

    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_BoeckMarco_Boeck Administrator, Moderator, Employee, Member, University Professor Posts: 1,993 RM Engineering

    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_singdharmender_sing Member Posts: 2 Contributor I

    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

Sign In or Register to comment.