How to get details from website and write into excel in table format with multiple rows

Help Activities
,
1

Hi
I trying to do a automation to get the details from website and write into excel in table category for each row. How can I go about it?

Eg, I trying to download multiple license (name, start date, end date) details from website for each individual into excel spreadsheet.

Can someone guide me how do I go about it putting the detail to excel?

Forum Engagement Daily Reports
2

Hi @eileen_ting

Is data in a tabular format on website? If yes, you can use extract data activity to extract all the data from website and save it in a datatable. Then write that datatable using write range activity into excel.

If data is not tabular format on website, then after you have fetched the details from website, you need to add row in a datatable (create a datatable first with the required columns) specifically. You can refer below thread on how to add rows individually to datatable. Once datatable is complete, you use write range activity to write the whole datatable in excel.

3

@eileen_ting

If all the data is same page then you can use data extraction which will give the output as table and can use it

If not for each ui element can be used to extract and create table using build datatable

Cheers

4

Hi I do tried using the data table extract. However when the table extract, when it search for the next new license number, the data table extraction go haywire.
I am trying to search one by one license details and extract to the excel spreadsheets

5

@eileen_ting

Can you please how data looks on the website?

Is it a table?

7

@eileen_ting

This doesn’t look like a table to me.

You might have to fetch data from each element on the screen individually.

1)Have a for loop for licence numbers
2) then enter licence number and data shows in the screen. So use get text activity to fetch details from each elements selector and save in data table. For e.v dt(“Name”)= value fetched from website for name.

  1. likewise assign values to other columns of sr data table. Once values are saved in daratble for one licence number. Add that data row into data table.

  2. loop runs for next license number.

Please note: selectors for get text for different license numbers and if there is any pattern in those. Use uiexplorer to analyze properties of selector and accordingly fine tune it to fetch values.

8

@eileen_ting

Hey you need to use get text or get attribute activities to get data and after each extraction add to datatable using add data row then at the end the datatable can be written to excel

Cheers