nice video but i have a doubt i have a input excel sheet in that sheet data starts at position of D5 to E10 and output also in that positions only can you explain
Thank you for the comment. Not sure if I understand you correctly. This is for the Excel WRITER so the nodes, that writes back into Excel. This has nothing to do with importing from different sheets. Maybe you can explain your problem a little bit more in detail. Thanks again!
Hello, I have a peculiar situation where I have an excel reader node going into a variable loop start to execute a sub workflow. I need to output the results of the sub workflows in separate sheets using the respective flow variables as names for the sheets. How can I accomplish this?
Hey Henry, thank you for the comment. You can basically take the flow variables, make them of data type string (s with a red dot) and then use the String Manipulation (Variable) Node to "create" your path. Once you have a valid file path string, you can turn it from string to path using String to Path (Variable) Node. Then you use that specific flow variable (different in each iteration, if I understand it right) within the Excel writer. Then simply make sure that you show the Flow Variable Ports (right-click on the node and activate this option) and connect this "outgoing" flow variable port to a Loop End Node using its Flow Variable Input Port. This will trigger the next iteration of the loop whenever the respective Excel file was written. Hope that helps.
nice video but i have a doubt i have a input excel sheet in that sheet data starts at position of D5 to E10 and output also in that positions only can you explain
Thank you for the comment. Not sure if I understand you correctly. This is for the Excel WRITER so the nodes, that writes back into Excel. This has nothing to do with importing from different sheets. Maybe you can explain your problem a little bit more in detail. Thanks again!
Hello, I have a peculiar situation where I have an excel reader node going into a variable loop start to execute a sub workflow. I need to output the results of the sub workflows in separate sheets using the respective flow variables as names for the sheets. How can I accomplish this?
Hey Henry, thank you for the comment. You can basically take the flow variables, make them of data type string (s with a red dot) and then use the String Manipulation (Variable) Node to "create" your path. Once you have a valid file path string, you can turn it from string to path using String to Path (Variable) Node. Then you use that specific flow variable (different in each iteration, if I understand it right) within the Excel writer. Then simply make sure that you show the Flow Variable Ports (right-click on the node and activate this option) and connect this "outgoing" flow variable port to a Loop End Node using its Flow Variable Input Port. This will trigger the next iteration of the loop whenever the respective Excel file was written.
Hope that helps.