Data extraction does not work on a web page

Help Activities
, ,
1

Hi, I’m new to Uipath development.
I’m trying to implement a robot that extracts data from a web page that is updated in real time. It turns out that when I open the excel file generated by this extraction, nothing is displayed. Please, whoever can help me.

2

^most of the case the selectors are to tune, when data is extracted and has empty result

3

hi,

Validate below check points

After data extraction add log message datatable.Rows.count if value is greater than 0 then validate you are passing the datatable to the excel file.

If value is less than 0 then that mean bot is not extracting data from website.

Let me know if you need further information to investigate the issue

4

Thanks for the answer. How could I get the right selector from a webpage?

[image]

5

is website specific. Just ry to remove any parts from selector which are not adding a meanfully value and which are not relaible e.g. generated parts, new calculated on page load.

Use </> from editor and feeld free to share the selector and the extract metada

6

Hi

Welcome to uipath forum

For data scrapping and an example on how to use it
Here you go

Once after data scrapping with the above steps
You will get the output as datatable variable
Let’s name it as dt

—now use a Writeline activity like this
dt.Rows.Count.ToString

If this shows some value more than 0 then dt has some value in it

Then you can write it to a excel with write range activity

Cheers

@Hamilton_Morais

7

Thanks for the answer. The number of rows in the DataTable is two. However, this result is not written to xlsx. I am using the “Append Range” activity to write the extract data.

image
image1366×768 104 KB

1 Like
8

I Could see only the message box
Use write range activity from workbook activities
Search as workbook in activity panel and choose write range from it where you can mention the excel file path and pass the input as ExtractedTable and enable the Property add headers

Cheers @Hamilton_Morais

9

Hi,

use write range activity and pass that datatable to it.

10

This is the method I use to write the data. Is it ideal to use the “write range”?

result
result1366×768 95.8 KB

11

Yeah it is
Append range is used to append to existing table in excel
But write range will either write the datatable to excel on top of the existing records that is it will overwrite or will enter it newly

Cheers @Hamilton_Morais

12

Good morning guys. Forgive me the delay. It still doesn’t work for me. Today I realized that in addition to being tables that are updated in real time, the structure is a table within a table. Can you see any solution?