List the Excel Worksheet Names with a Batch Macro

I have a very simple Batch Macro, attached. This is intended to take a Control Parameter (a full file path) and get the Excel Sheet names.

The idea is that I can push a lot of Excel full file paths to the macro, and it will list out the Sheet names.

For some reason the macro stops after the first iteration, and I don't understand why.

ExcelMultiFile1.yxmc

Developer

Macros

Accepted answers

JosephSerpis

Hi @Hiblet from your earlier screenshots I can see you don't have a browse tool after your batch macro. Can you add one and try again I got the same error as you "1 iteration were run (ended by a downstream tool) when I removed the browse tool after your batch marco. The batch macro requires an output for it to iterate correctly.

All comments

joshuaburkhow

Wondering why you would need this as there is already a tool that does this 😉 ..... Dynamic Input Tool

JosephSerpis

Hi @Hiblet the marked solution on this post might help you.

Hiblet

Hi @joshuaburkhow , this is just the start point for a something that will try to find some particular sheets and try to pull each one in. They are potentially all sorts of formats. Think Dynamic Input with variant schemas. But, having fallen at the first hurdle, I have to wind my neck in a bit!

Hiblet

Hi @JosephSerpis , that is helpful, but not what I am looking for. I am not so much looking for the solution, as for understanding as to why my batch macro runs just one iteration. From my understanding, the macro should step through each input, get the sheet names, and output all the sheet names for the files, but it runs one iteration and stops. Thanks for the reply though.

JosephSerpis

Hi @Hiblet I ran your macro it's working as expected in the below screenshot I fed in two excel files each having 3 sheets hence why I have six records.

Hiblet

Hi @JosephSerpis , that is weird, I get the macro stopping after one iteration on my machine. The two attached JPEGs show the yxdb that I push into the macro (list of 3 files) and the other shot shows the feedback from the run. I have attached the XLS sheets, they are just simple place holder fakes, not actual sheets with useful data.

FlowResult1.jpg

FlowResult2.jpg

Example Excel File.xlsx

Planning File.xlsx

Test.xlsx

Quick Links

Unanswered
Community Events
Groups

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335