Excel data transfer

[m.a.akay]

Hello,

After selecting the relevant fields from a site with a drop-down menu, I will export all the resulting data one by one to Excel. What activity can I do this with?

[ashokkarale]

@m.a.akay,

You should be using Table extraction

If you you scattered data unable to extract with Table Extraction, you can use Get Text activity to get desired data and add it to DataTable using Add Data Row activity.

Once you have the DataTable you can use Write Range activity to write it to Excel file.

Thanks,
Ashok

[m.a.akay]

Does the menu in the video work?

[ashokkarale]

@m.a.akay,

Do you want to select the dropdown?

[m.a.akay]

I want to select names from the drop-down menu and export them to Excel

will select them in order and export them to Excel

[ashokkarale]

@m.a.akay,

You can get them by Find Children activity. Checkout this thread for more details.

Unable to get Dropdown items using "Find Children" activity - CoWin

I am trying to get the list of all states from the Cowin website, So I am using the “Find children” activity. But I’m unable to get the list of “states”. [image] When I checked the output of Find Children in Locals variable , below is the output received : UiElement[1] { UiElement { ClippingRegion=null, Selector=“” } } [image (1)] and the highlighted element showing below is the one that I selected for the “Find children” activity. [image (2)] I tried selecting both “Find Children” and…

Thanks,
Ashok