Error Executing background job 'Loading Excel File':

dharmender_sing

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)

Marco_Boeck

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

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

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