Write cell activity

I need insert a row in excel sheet “D5” using write cell…Please help

Hi @soumi_soumiya

I’m not exactly clear on the requirement. So you want to write only in cell D5 or so you want to start writing a row from D5?

@soumi_soumiya if you want to write D5 cell only,as you said you can go with write cell activity.
-use excel applicationscope and read range and store it in a vatiable.
-say you want to write newdata value in D5 cell
Save that newdata value to a variable.
-now use write cell activity and give the variable as input and place the cell as D5
Hope you got it.

yes i want write a word in D5 column for that i am using write cell but its not working

i have given like this only but its not working

@soumi_soumiya

Your write cell activity is correct only and after that you are using Write Range activity and trying to write into same file. May be because of that it’s overriding existing data.

i want to write it in same excel only for that i have tried ti insert using write cell activity.what shal i do now


This my excel i want to write in exception column D row

@soumi_soumiya

Remove Write Range activity after Write Cell activity and then try it.

Are you getting any error here?

@soumi_soumiya

Other option is,

Use write range first, and then do the Write cell activity so that write cell does not get overwrite by write range

1 Like

Its working thanks

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.