Dynamically retrieve table names

[jjinsig]

Hello, 

I have a list of files: 

File Name	Path
File1	C:\File1.xlsx
File2	C:\File2.xlsx

I would like to use the above to dynamically generate a list of table names associated with the files: 

File Name	Path	Table Names
File1	C:\File1.xlsx	Table1a
File1	C:\File1.xlsx	Table1b
File1	C:\File1.xlsx	Table1c
File2	C:\File2.xlsx	Table2a
File2	C:\File2.xlsx	Table2b
File2	C:\File2.xlsx	Table2c

What's the best way to go about doing this? 

Thank you. 

[gabrielvilella · Accepted solution]

If you want to retrieve the list of sheet names for a list of Excel files you have two options:

1. If the schema is the same among them, you can use the Dynamic Input, having the template set up to retrieve the list of sheet names.
2. If the schema is not the same, you need a batch macro (attached) to get the list of sheet names, same way as you'd need to read them. 

[Qiu]

@jjinsig 
Just a different way of interpreting your intention.