🎉 🎉 RAPIDMINER 9.10 IS OUT!!! 🎉🎉

Download the latest version helping analytics teams accelerate time-to-value for streaming and IIOT use cases.

CLICK HERE TO DOWNLOAD

"Slow reading Excel files"

SintaiSintai Member Posts: 3 Contributor I
edited May 2019 in Help
Hi,

I have this problem, I have an excel file with 20 sheets, 60 attributes, and 60 rows(file have about 1MB). And when I choose this file for import, file reading takes about 7 minutes and it is so long time, if I  need import every sheets. Can I import all of sheets in one import process or Is some way How can i speed up this process?

Thank you. 
Tagged:

Answers

  • IngoRMIngoRM Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, Community Manager, RMResearcher, Member, University Professor Posts: 1,751  RM Founder
    Hi,

    yip, this would be possible by using the "Read Excel" operator in a loop where you use the macro "%a" for the sheet parameter. Also use %a in the data set name for writing otherwise you would override the data in each iteration. This way you could automatically import and store all sheets in one single process.

    Cheers,
    Ingo
Sign In or Register to comment.