🎉 🎉 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

Excel worksheet loop using Macro

mikedmiked Member Posts: 18 Contributor II
Hi All - I'm having trouble with something I thought would be relatively easy and unable to get through it. I basically would like to "Read Excel" in a loop by using a macro to loop through however many sheets are in this file as they can change from month to month. The data structure is the same on each tab but each contain a different element.   If possible would also like to create an attribute using the tab name so I can track where the data came from. Any help would be appreciated. Thanks

Best Answers

  • mschmitzmschmitz Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,123  RM Data Scientist
    Solution Accepted
    Hi,

    Operator Toolbox has an operator called 'Read Excel Sheet Names' to get the names of the tabs. You can then loop over it and read each tab.

    Best,
    Martin
    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
    miked
  • mschmitzmschmitz Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,123  RM Data Scientist
    edited October 19 Solution Accepted
    Hi,
    attached is an example process and excel file.
    Best,
    Martin
    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany

Answers

  • mikedmiked Member Posts: 18 Contributor II
    Thank you! 
  • mikedmiked Member Posts: 18 Contributor II
    @mschmitz
    Hi Martin - Apologies but still struggling a little bit - would you be able to show a quick Loop example with the Read Excel Sheet Names operator? 
  • mikedmiked Member Posts: 18 Contributor II
    Thanks so much...appreciate the help! 
    mschmitz
Sign In or Register to comment.