Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.

Array Index Error during 'Loading Excel File'

JpganucheauJpganucheau Member Posts: 6 Learner III
edited January 2020 in Help
Every time I try to load any of our company data (which is confidential and I can't post here), I get the following error:

  • Exception: java.lang.ArrayIndexOutOfBoundsException
  • Message: 3
  • 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)

Any suggetions? (again I'm not allowed to upload our data here for help further)
Tagged:

Best Answer

  • JpganucheauJpganucheau Member Posts: 6 Learner III
    Solution Accepted
    Looks like our BI platform was just exporting corrupt Excel files. Opening it and resaving it again on my machine got it to work. Thanks @sgenzer

Answers

  • sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,959 Community Manager
    hi @Jpganucheau well that's a new one. Can you at least share your setup: RM version, hardware, operating systems, RM license type, etc..?
  • JpganucheauJpganucheau Member Posts: 6 Learner III
    RM Studio 9.5.001 (rev: 24d768, platform: OSX) Trial Edition
    MacBook Pro (15inch, 2018) - 2.2GHz 6-Core i7 - 32GB RAM 3200
    MacOS Catalina Version 10.15
  • Marco_BoeckMarco_Boeck Administrator, Moderator, Employee, Member, University Professor Posts: 1,996 RM Engineering
    edited January 2020
    Hi,

    May I ask how the Excel files are created? Because I suspect they are not created by hand with a regular Excel version, as that particular error looks like it can only happen if the Excel file violates the ECMA-376, 4th Edition format specification.

    What basically happens is that the xlsx file is asked "how many cell formats do you contain?", it says x, and then later on a cell says "hey, my cell format has id x+1". Which means the xlsx file lied in its answer to the first question.

    Regards,
    Marco
  • sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,959 Community Manager
    @Jpganucheau thank you for the system config. By sheer chance I have the exact same setup that you do, so if you want you can share the xlsx privately with me via OneDrive (I will send you an invite) and I can test it offline.

    Scott
  • JpganucheauJpganucheau Member Posts: 6 Learner III
    @Marco_Boeck thank you for that insight, I might be able to pass that along to the people that generate the excel files.
    @sgenzer I'm checking with my superiors to see if I would be able to do that

    Thanks,

    Jonathan
  • JpganucheauJpganucheau Member Posts: 6 Learner III
    @sgenzer I got approved to be able to send you this erroring data set privately via OneDrive. Can you send me an invite? My email is jonathan_ganucheau@tsco.org

    Thanks,

    Jonathan
  • sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,959 Community Manager
    hi @Jpganucheau no problem. Just shared a OneDrive folder with you.

    Scott
  • JpganucheauJpganucheau Member Posts: 6 Learner III
    @sgenzer I just uploaded the file. Let me know if you can figure out what's wrong, and please keep that file under wraps.

    Thanks,

    Jonathan
Sign In or Register to comment.