Lets say I have a workbook that has 2 sheets. I need to read in the first sheet, go through and complete each row, and write the results back into that specific sheet and move to the next. How can I accomplish this using the framework. My 2 initial ideas:
- Have a sequence that calls the framework with TransData set to the first sheet and then moves to the second sheet
- When shouldStop is set to true, set it back to False and set the transData to the second sheet and continue process. Once it finishes the second sheet, process is also done.
Thoughts? Am I missing an easier solution?