Hi, Facing issue while extraction the data and feeding into the particular excel row “C”
It’s starting writing from the C3 and when the loop iterates the second times it remove the C3 data overwrite the data in C3 cell. Can you plz help. @Palaniyappan
Hi buddy @balkishan
may i know what is the default value of Count
Kindly write cell if you are trying to write on a particular column row by row
Cheers @balkishan
1 bro
put the default as 2
and place the count assign activity next to write cell activity buddy @balkishan
Now it’s not writing anything
use Write Cell activity instead of Write Range activity.
If your input data is DataTable then use ForEach Row activity but not ForEach loop.
fine i hope email is the output obtained from matches activity
–use a excel application scope and pass the file path as input
–inside this scope use a for each loop and mention the matches output
–inside the loop use a write cell activity where mention the range as “C”+Counter.ToString
where Counter is a variable of type int32 and default value of 2
and mention the item as input to write cell activity
–next to write cell activity use a assign activity like this
Counter = Counter + 1
Kindly try this and let know buddy
Cheers @balkishan
May i know why add data row is used buddy,
are we trying to enter a row of values or just the email value from matches to the column email to the excel
Cheers @balkishan
Bro, I am using regex here so before the loop I create a Build Data Table and used Match Activity. Inside loop I am using the Add data row activity.
Sorry i did not understand what you are trying here.
Could you please tell me what are you trying and also the steps you followed to do this. Then i can help you better in this.
Bro I am extracting email from the bulk text. So I have used Regex to filter the email only.
I have used Build Data Table and then Match activity. Inside the Loop I have used the Add Data Row
Below is the step I have followed. Basically I want to write the email address in the column C
Hi @balkishan,
can you explain your scenario in detail and share your Excel File. so, we can help you.
in Write Cell Activity you can give the String not the DataTable.
Fine @balkishan
i hope you have created a datatable with a column Email in it
–then used a match activity to get the value for the column Email
–then used a for each loop to add the value of matches into the datatable by means of add data row…
am i right…?
if so dont use write range within the for each loop, let the add data row add the value of matches to the column email in the build datatable and as the for each loop iterates, it will add all the values to the column to each row one by one
–next to for each loop use this write range workbook activity and mention the range as “”
Cheers @balkishan
Bro string is not static it’s coming from the candidate profile.
Like this if you see there is email which I have to extract. This is diff in each profile. It’s extracting the correct email I’d from the text. Only the issue while writing into the excel column C.
You’re right bro, but the above points I didn’t get.
No bro I have total three column,
where in the 1st I am writing the Candidate name, second their Phone number and in column C I am writing the Email I’d.
For Name I am using the Data Scrapping and for Phone I am using the Get Full Text. But for Email Id these above method are not working so I am using Match - Regex.
For Name and Phone number no issue I am getting the correct value in the excel. But the issue with Email Id where I am writing into column C.
I used the String Manipulation for email I’d. But the array is not static. sometimes the index become 2 and sometime 3. So String manipulation is also not working there.
if so kindly follow the below steps buddy
–use a build datatable activity and mention the column name and datatable name as DT…this is done, fine
–use a matches activity and get the values of email as a collection, this is done
–Then use a for each loop and pass the output variable of matches to it
–inside the for each loop use a add data row and mention the array row property as {yourcandidatevalue.ToString,yourPhonenumber.ToString,item.ToString}
–Now come out of the for each loop and use a write range activity where mention sheetname and range as “” and mention the datatable as DT, which has the added values of email because of add data row
Cheers @balkishan
Hi @balkishan,
in your case do like below,
you said you already build datatable before for each loop.
After matches you want to add the email address to that datatable
then why you are using Add Data Row…?
use the code below…
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu