read all sheets from an XLS file in a loop

When I try to read all sheets from an xls file in a loop(see the sample from the server), there is new column called Iteration which the loop time was recorded.

However, my problem is that is there any method that in the new column the sheet name can be recorded instead of the iteration time. 

Thanks for your help!

Regards,

Kevin

 

Hi Kevin,

the iteration is appended using the loop end node, you can also deactivate it in the loop end node.

If you want to have the file name, place a Variable to Table column node before the loop end node (and after the xls reader) and configure to include the sheet name variable.

Best, Iris 

Hi Iris,

Thank you very much! It works!

Have a nice weekend!

Kevin