Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Excel worksheet loop using Macro

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

Find more posts tagged with

AI Studio

Excel

Loops + Branches

Macros

ETL + Data Prep

Accepted answers

MartinLiebig

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

MartinLiebig

Hi,

attached is an example process and excel file.

Best,

Martin

All comments

MartinLiebig

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

miked

Thank you!

miked

@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?

MartinLiebig

Hi,

attached is an example process and excel file.

Best,

Martin

miked

Thanks so much...appreciate the help!