Bug Reports: Error in loading excel file
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)
Find more posts tagged with
Sort by:
1 - 4 of
41
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.
Altair EmployeeHi @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.
You woun't have the same problem if you use the read excel operator.
Hi @MarcoBarradas, Thank you for your instruction.
Sort by:
1 - 1 of
11
Altair EmployeeHi @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.
You woun't have the same problem if you use the read excel operator.
David