"Import Excel Sheet on Rapidminer - Problems"

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

Find more posts tagged with

AI Studio

Excel

Accepted answers

All comments

RWingerter

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

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!