"Import Excel Sheet on Rapidminer - Problems"

mdna
mdna New Altair Community Member
edited November 5 in Community Q&A
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

  • RWingerter
    RWingerter New Altair Community Member
    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
  • MacPhotoBiker
    MacPhotoBiker New Altair Community Member
    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!

Categories