I need insert a row in excel sheet “D5” using write cell…Please help
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
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
Remove Write Range activity after Write Cell activity and then try it.
Are you getting any error here?
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
Its working thanks
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.