This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I've written several similar answers in other threads. Are your Sheet Names in the files variable or something constant like "Sheet1"?
Assuming your sheet names are constant (or at least predictable, like the sheet name is the same as the file name) then the below sample should be what you need.
This scenario is perfect for a Batch Macro. The Control Parameter will be used to drive selection of a single source Excel file / sheet. The sample below is a workflow that gets file names from a directory, then calls a macro to take action on each file.
The macro will handle the activities you'd perform against a single file like writing it to a separate database table. The macro will be called by a parent workflow that passes in the list of files to take action on. In my sample macro I've got a placeholder Container with a dummy Filter tool that you'd replace with any actual logic needed on the data in a given file.
Simple parent workflow to gather file names and pass into batch macro: