use variable as sheet names in the one loop

APAC Operation Report.knwf (92.3 KB)


image

Hello, in my case I would like to extract the “Month info.” from one cell as varibale to name the sheet afterwads, I build the varibale connection, but, in the Node “excel writer” the varibale is missing to select,I no’t sure if this is the best way, would you please advise? thank you!

Hello @Tigerfox,

I think you haven’t clicked the option of propagate modified loop variables in the Loop End node.

1

See if it works…

1 Like

I find the solution maybe by coincidence, it works now. here is my solution with a cell extractor as variable to rename the sheet names.

1 Like

thank you, it’s not the point, and I make it work now, pls find my solution as following.

Thanks for sharing your solution.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.