The RapidMiner community is on read-only mode until further notice. Technical support via cases will continue to work as is. For any urgent licensing related requests from Students/Faculty members, please use the Altair academic forum here.
Array Index Error during 'Loading Excel File'
I get the following error in loading an Excel file that was created with MS Access.
- Exception: java.lang.ArrayIndexOutOfBoundsException
- Message: 1
- 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)
0
Best Answer
-
jacobcybulski Member, University Professor Posts: 391
Unicorn
I have read your Excel file in without any problems. So I suspect that this issue is something to do with your installation. First of all, the Excel file has nearly 65k records. Are you using a free license, which limits your data size to 10K perhaps? Alternatively, it is possible that you are running out of RAM of your computer - as a test try deleting all rows above 10,000, save it and see what happens. Also I have tried reading your file with version 9.6 and 9.7 of RapidMiner, if your version is older update it to the most recent one first.
5
Answers