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
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 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
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 “”
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.
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