Bug Reports: Error in loading excel file

trioktap

I have an error in loading excel file, it stated that there was an error during executing the background job. Here is the detail of the error:

• Exception: java.lang.ArrayIndexOutOfBoundsException
• Message: 7
• Stack trace:
• com.rapidminer.operator.nio.model.xlsx.XlsxNumberFormats.setCellNumberFormatId(XlsxNumberFormats.java:65)
• com.rapidminer.operator.nio.model.xlsx.XlsxNumberFormatParser.parseNumberFormats(XlsxNumberFormatParser.java:144)
• com.rapidminer.operator.nio.model.xlsx.XlsxResultSet.(XlsxResultSet.java:248)
• com.rapidminer.operator.nio.model.xlsx.XlsxResultSet.(XlsxResultSet.java:329)
• com.rapidminer.operator.nio.model.xlsx.XlsxSheetTableModel.(XlsxSheetTableModel.java:113)
• com.rapidminer.operator.nio.model.ExcelResultSetConfiguration.createExcelTableModel(ExcelResultSetConfiguration.java:216)
• com.rapidminer.operator.nio.model.ExcelResultSetConfiguration.createExcelTableModel(ExcelResultSetConfiguration.java:193)
• com.rapidminer.studio.io.data.internal.file.excel.ExcelSheetSelectionPanelModel$1.loadTableModel(ExcelSheetSelectionPanelModel.java:212)
• com.rapidminer.studio.io.data.internal.file.excel.ExcelSheetSelectionPanelModel$1.run(ExcelSheetSelectionPanelModel.java:176)
• com.rapidminer.gui.tools.ProgressThread$3.run(ProgressThread.java:586)
• 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_Barradas

Hi @Loan_Nguyen56 please open you file with excel and remove all the columns after the last data point. I had the same problem opening it but deleting the blank columns and the blank rows fixed the problem. That happens if you open it with the upload assistant.
You woun't have the same problem if you use the read excel operator. 

David_A

Hi @trioktap ,

I guess you can't simply share the file with us?

But can you say if there are any unusually cells in the file? My first guess from the error message would be, that there is a problem parsing some numbers in a cell.

Best,
David

Loan_Nguyen56

I have the same problem with Loading Excel file. However, difference error massage. How can I fix this error because the first time I try to use rapidminer. Thanks for your support.

Marco_Barradas

Hi @Loan_Nguyen56 please open you file with excel and remove all the columns after the last data point. I had the same problem opening it but deleting the blank columns and the blank rows fixed the problem. That happens if you open it with the upload assistant.
You woun't have the same problem if you use the read excel operator. 

Loan_Nguyen56

Hi @MarcoBarradas, Thank you for your instruction.