RapidMiner Wisdom Banner

Array Index Error during 'Loading Excel File'

JpganucheauJpganucheau Member Posts: 5 Learner I
edited January 13 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)
Jasmine_

Answers

  • sgenzersgenzer 12Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,717  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..?
    Jasmine_
  • JpganucheauJpganucheau Member Posts: 5 Learner I
    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
    sgenzerJasmine_
  • Marco_BoeckMarco_Boeck Team Lead Software Engineering Administrator, Moderator, Employee, Member, University Professor Posts: 1,873   RM Engineering
    edited January 14
    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
    sgenzerJasmine_
  • sgenzersgenzer 12Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,717  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
    Jasmine_
  • JpganucheauJpganucheau Member Posts: 5 Learner I
    @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
    Jasmine_
  • JpganucheauJpganucheau Member Posts: 5 Learner I
    @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 [email protected]

    Thanks,

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

    Scott
    Jasmine_
  • JpganucheauJpganucheau Member Posts: 5 Learner I
    @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
    Jasmine_
Sign In or Register to comment.