loop using xls append

Hi Guys,

 

Im trying to create a loop that will read multiple txt files and append each txt file to a seperate worksheet in an excel workbook but I am having trouble working it out.

 

I have

Table Creator > TableRow to variable loop Start > List files > TableRow to variable loop Start > File Reader > XLS Sheet Appender > Variable loop end

 

The table create and first TableRow to variable loop start nodes are used to pick up variables that are used in the List Files node to pick up particular files.

 

If anyone has suggestions that would be great.

 

Cheers

Hi Andy, 

Check out the attached workflow.  It should get you pointed in the right direction. I use a counting loop and a data generator, but this should be easy to adapt to your use case. 

Regards,

Aaron