"Import Excel Sheet on Rapidminer - Problems"

mdnamdna MemberPosts:2Contributor I
edited June 2019 inHelp
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 MemberPosts:38Contributor 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 MemberPosts:60Contributor 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 InorRegisterto comment.