Append to existing sheet if file exists and create file if it doesn't exist

jaimonsk

Hello Experts,

I am looking for a way to create a new excel sheet if the file does not exist and append to existing file(also sheet) if the file is already present and write data to them .

For example,

We need to dynamically create a file called "test_exec. xlsx" if the flag is set as "0" and append to existing sheet if flag is set as "1"

Can somebody help me on this?

Thanks in advance

danilang

Hi @jaimonsk 

@afv2688 has a good solution, but you can accomplish the same result in a simple workflow...no macros required. 

The Output tool on the top branch is configured to create the file if it doesn't exist.  The bottom one appends if the file does exist.  The directory browser read the files from the target directory and joins this with the list of filenames from the data.   Matches, which correspond to existing files, are routed to bottom output.  Non-matches go out the L output where the file is created.

Dan

AppendOrCreate.yxmd