Dynamically Import Multiple Excel sheets starting at a particular row

[Hamster]

I've been trying to figure out how to dynamically Import Multiple Excel sheets starting at a particular row. I have a batch macro with a Dynamic Input tool that pulls in each sheet. But I need it to start from row 10 each time.

All the schema's are the same.

[AngelosPachis · Accepted solution]

Hi @Hamster,

Not sure how your batch macro is configured exactly, but I would say you could use a sample tool inside your batch macro that will skip the first 10 rows of each sheet, as shown below.

Please find the workflow attached. Does that answers your question in a way?

Regards,

Angelos

[Hamster]

Hi Angelos, 

Thanks for that.