Excel Exception :the range does not exist

Help
,
1

hlo
while i was storing data into excel sheet through iterations using write cell activity it showing the range does not exist.

Screenshot%20(78)
Screenshot%20(78)1920×1080 180 KB
Main.xaml (9.8 KB)

2

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.

3

hlo @Mateus_Cruz
i have attached the workflow once you check it.

4

Instead of using the variable that the For Each activity gives you (item), you are creating a new variable inside the loop called counter. But counter isn’t initialized and it’s not incremented, so it’s not doing anything there.

To make it work, you should:
-Delete the counter variable that you created inside the Do
-Change item to 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)

5

thank you so much @Mateus_Cruz

6

hlo @Mateus_Cruz
it showing Exception from HRESULT:0x800AC472