How to write data of a get text activity to a specific column in excel sheet

I have excel file (CSV) which looks like this

I have a get text activity which contains some data and it is running in a for each loop

Now How do I add that get text activity data in this state column of my above excel sheet

Excel File -
Book1.xlsx (9.0 KB)

1 Like

Hey @Ishan_Shelke1

Could you please explain how do you want to actually add from Get Text to Excel ?

Thanks
#nK

Hello @Ishan_Shelke1 ,

As you mentioned you are using a for loop. Are you looping through the rows in the excel and getting some value from excel and doing some action in the application?

I yes, then you can use the same loop to update the value in the excel. Use Write cell activity.

Else give some more clarity to the automation process which you are doing.

refer to this
Extract Zip Code Details.xaml (17.1 KB)

you can extract statename from url

  1. use get attribute to get url
    image
  2. use regex to extract statename from url
    statename = System.Text.RegularExpressions.Regex.Match(url, "state=(.*?)\&").Groups(1).Value.ToUpper
  3. add data column to finalTable with default value=statename

result
image

I want to extract the full statename from the url Not the abbreviation of it so what regex expression it would be ?

refer to this xaml
Extract Zip Code Details.xaml (17.1 KB)

full state name is here

to extract it, change the regex to this
System.Text.RegularExpressions.Regex.Match(url, "stname=(.*?)$").Groups(1).Value

result
image

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