The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

"Import Excel Sheet on Rapidminer - Problems"

mdnamdna Member Posts: 2 Contributor I
edited June 2019 in Help
Hello,

I would like to import an excel sheet containing 80000 rows. I try several times to load the excel sheet but It hasnt been possible to upload it. I don't know why.
Is there a maximum number of rows that an excel sheet must respect to be able to import it on Rapidminer ??? Are there other alternatives ?

Thank you for your help
Tagged:

Answers

  • RWingerterRWingerter Member Posts: 38 Contributor II
    Quote from Help on "Read Excel": "This operator can be used to load data from Microsoft Excel spreadsheets. This operator is able to read data from Excel 95, 97, 2000, XP, and 2003."

    The max. number of rows in these older versions of Excel is 65,536. As an alternative xou could use the "Read CSV" operator.

    Roland
  • MacPhotoBikerMacPhotoBiker Member Posts: 60 Contributor II
    In addition to Redegniw's comment, you probably should save your excel sheet as a csv file first. csv and xls are not the same, although excel tends to make the use of csv files so simple that it sometimes seem that they are.

    Please note if you choose "save as csv", only the current worksheet will be saved.

    Good luck!
Sign In or Register to comment.