The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

"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 Employee-RapidMiner, 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.