RapidMiner 9.7 is Now Available

Lots of amazing new improvements including true version control! Learn more about what's new here.

CLICK HERE TO DOWNLOAD

Array Index Error during 'Loading Excel File'

JpganucheauJpganucheau Member Posts: 6 Contributor 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_

Best Answer

  • JpganucheauJpganucheau Member Posts: 6 Contributor I
    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
    sgenzer

Answers

  • sgenzersgenzer 12Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,952  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: 6 Contributor 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,938   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,952  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: 6 Contributor 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: 6 Contributor 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,952  Community Manager
    hi @Jpganucheau no problem. Just shared a OneDrive folder with you.

    Scott
    Jasmine_
  • JpganucheauJpganucheau Member Posts: 6 Contributor 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.