while i was storing data into excel sheet through iterations using write cell activity it showing the range does not exist.
With what value is your
counter variable initialized? A common mistake is to try to write to row 0, but Excel rows start at 1.
If that’s not the problem, please attach a sample workflow that reproduces the error.
Instead of using the variable that the For Each activity gives you (
item), you are creating a new variable inside the loop called
counter isn’t initialized and it’s not incremented, so it’s not doing anything there.
To make it work, you should:
counter variable that you created inside the
counter in the For Each activity
Also, I noticed that you are not using output variables for the second and the third Input Dialog activities, so you won’t get anything from them.
Take a look the modified workflow: PatientModified.xaml (9.9 KB)