Error Executing background job 'Loading Excel File':

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
-
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
0 -
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
0 -
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
0