I wanted to write into the specific column by looping through it? Is there any way to this?
You can use for each row and inside you can use assign activity
row(“Column name”) = Yourvalue
it’s throwing this error
Can you show the InputData via some Screenshot and the expected exact output for the same
Happy Automation 
Best Regards
Er Pratik Wavhal 
Hii @ Pratik_Wavhal
I am attaching the screenshot of input data for your reference…
if you want me to upload whole XAML file I will upload that too
Inside for loop please write if condition to match the required column and use assign activity to append value.
or
Use column loop instead row loop
hey @ rrkadari
its not working with the column loop.
Can you please demonstrate with if condition by code.
You should use Write Cell Instead of Assign Activity as below :-
I am attaching the workflow for the same :-
MainPratik.xaml (7.5 KB)
Note :- Within WriteCell Activity in the Range property instead of “A” use the Alphabet Letter of the column in which you want to write the Values
Mark as solution and like it if this helps you 
Happy Automation
Best Regards
Er Pratik Wavhal
thanks for your efforts Pratik_Wavhal but its not working. may be its problem from my end let me share my project with you.
Project : I am extracting data from database where customer’s email and phone number is stored. then, i am writing this data into the excel sheet and from that excel sheet i wanted to send the email to the customer and update the status as timestamp into the column called email_status.
Sorry I don’t know why I am not able to upload the xaml file. it says new users can’t upload files
UpdateCellBasedOnColumn.xaml (9.8 KB)
Hope this helps you. My studio version is 2019.10
No issue. I have made one workflow which will give you the idea that what changes you should make in your workflow.
Below is the workflow for the same :-
MainPratik.xaml (9.4 KB)
New Microsoft Excel Worksheet.xlsx (9.1 KB)
Input :-
Output :-
If possible you have Gmail Account then can you upload your file on Google Drive der and then share the Link here for the same if you are not getting what actual you have to do in your workflow
Happy Automation
Best Regards
Er Pratik Wavhal
Hello @rrkadari @Pratik_Wavhal https://drive.google.com/drive/folders/1PjquFP_WBAeJhscyJ2Np2Yt5YCgcAUeQ
above folder has that XAML file. I’m an absolute beginner in this RPA world so thanks for helping me, maybe I am doing some things the wrong. adding my file for your reference. Thanks in advnace !!
1 Like
If possible can you please give the access
Happy Automation
Best Regards
Er Pratik Wavhal
have you tried the code which i attached?
Hi @rrkadari
Which activity is der in place of missing Activity ??
Even though i am doing Repair Dependencies it is not getting repair
Happy Automation
Best Regards
Er Pratik Wavhal
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
ashokkarale
singh_sumit
alonica
SorenB
manasrlenka25
Firat_SECKIN_BULUT
Lahiru.Fernando
ruchirmahajan
RyanTSG
Nitesh