If I have an excel file from which I want the project to grab data from, how can I set it so that on the next execution it will take the next line?
Options I see:
1. Delete line after taking, and take the first one all the time.
This option will not work because I cannot delete the info, it must add info to it.
2. Move the line to the end, and take the first one all the time
This option would work, but would cause problems when multithreading (two instances might take the same line)
3. Create a textfile with numbers 1..2..3.. and delete each after taking. This will be a variable of the line in excel to take.
This option would work, but if the project fails - it would not return to that line.
Are there any other simpler ways of achieving this?
Thanks.
Options I see:
1. Delete line after taking, and take the first one all the time.
This option will not work because I cannot delete the info, it must add info to it.
2. Move the line to the end, and take the first one all the time
This option would work, but would cause problems when multithreading (two instances might take the same line)
3. Create a textfile with numbers 1..2..3.. and delete each after taking. This will be a variable of the line in excel to take.
This option would work, but if the project fails - it would not return to that line.
Are there any other simpler ways of achieving this?
Thanks.
