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)
Find more posts tagged with
Sort by:
1 - 6 of
61
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.
If you have an educational license you have no limit on the data size (check About RapidMiner and there it will be written what is your license). The issue may be to do with your environment, e. g. the version of Java on your computer or with one of the extensions being fault. Try saving the Excel file as CSV and see if you have the same problem reading it in this form (as some of your columns have # signs, make sure that when you read the CSV file in, either you remove the # characters from the column names prior to exporting it from Excel or click off the Read CSV option to use it as a comment character).
Sort by:
1 - 1 of
11
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.