Excel Exception :the range does not exist

excel
activities

#1

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

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