How to add new sheet dynamically to multiple files in a directory

Hi,

I am looking to create a workflow that allows the user to use a interface tool which passes through a sheet name to multiple files on the shared. I am able to create the interface tool part but having a hard time figuring out the best tool to use to create a new sheet on all the files in a folder.

Any help would be greatly appreciated.

Workflow

Output

Help

Accepted answers

SPetrie

I mocked up a test using a batch macro. See if this is what you are looking for and you may be able to integrate it into your flow. The workflow and a few files to test with are attached.

SheetSelector.yxzp

NewSheetFiles.zip

All comments

SPetrie

Are you adding the same data/sheet to every file as well?

Using the output of a directory tool and appending the full path with sheet name appended to it to use in your output tool should work.

You could also come up with a batch macro that passes the full path of every file in the target directory and the new sheet name to it and outputs that way.

The batch macro is probably your best bet since joins or appends can get nasty depending on the number of files and rows of data involved.

jsilavong

Yes i am adding the same sheet and sheet name to all the files.

jsilavong

Yes i am adding the same sheet and sheet name to all the files.

SPetrie

I mocked up a test using a batch macro. See if this is what you are looking for and you may be able to integrate it into your flow. The workflow and a few files to test with are attached.

SheetSelector.yxzp

NewSheetFiles.zip

jsilavong

Thank you ! This is exactly what im looking for.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703