"Slow reading Excel files"

SintaiSintai MemberPosts:3Contributor I
edited May 2019 inHelp
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 ProfessorPosts:1,751RM 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 InorRegisterto comment.