Forum Discussion
4 Replies
Sort By
- vincent_goudeOccasional ContributorYou can do this either by using DataDrivenLoop with If...Then structure and Go To Label or by scripting.
First solution:
1-Do as usual your DataDrivenLoop
2-use a If...Then Structure to check if a line is not burned.
3-If so run your treatment, change a column in you Spreadsheet to mark the line as burned
4-Then Go To Label out of the loop once you've done one treatment.
Second solution:
Instead use variable and DataTable function like <DBTables>.Values(aRow, aColumn) to get to a specified line, do your treatment and burn/mark the line as used. - karkadilValued ContributorNo, it is not possible. You have to open the file each time and read the content in a loop until you reach the necessary row.
- StuNew ContributorYou could run a short script just to loop around the spreadsheet, select the necessary row, and pass that row as a parameter into your main script.
Stu - cykocivNew ContributorGot it, Thanks for the help!
Related Content
- 3 years agozokirsalomov
- 4 years agoaqibkotwal
- 3 years agolydeeea
Recent Discussions
- 2 days agoMW_Didata