Array Index Error during 'Loading Excel File'

Hac

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)

jacobcybulski

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.

Hac

I have 9.7 and I am using an educational version. I am getting the same error with a much smaller file.  I do not know the limits of the version I have.

jacobcybulski

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). 

Hac

I have found that the number of lines is not the problem; the number of columns is the issue.  I can only use 16 columns for a file import.

jacobcybulski

Great you've found the problem, however, I also use educational license and do not have such restrictions. I regularly import very large CSV and Excel files.

Hac

The questions now are - why do I have the restriction and can it be changed?