Add data and data scraping

Help Studio
, , , ,
#1

hello, I’m trying to add the data I got from data scraping to add data. When I write extractDataTable in the data row, it gives an error because there is no datarow. Can you help me to fix it?

Forum Engagement Daily Reports
#2

Hi @irem_dogan

Welcome to Uipath community

If you need to handle this error.

You can try with extractDataTable .Rows.Count>=1 in the If activity.

Regards
Gokul

1 Like
#3

@irem_dogan can you show me how you are adding data in datatable

#4

I’m pulling data with data scraping

#5

image
image400×577 20.2 KB

#6

@irem_dogan can you show me ExtractDataTable type.
why you are not using arrayrow?

#7

I tried because I didn’t know how to use it, but I couldn’t find how to convert the data.

#8

@irem_dogan give me code I can adjust

#9

By using this method you can add row by row only
Instead of
write the data into excel for 1st time and use clear DataTable
The next loop use Append Range activity and a clear data table

repeat the process, values will append in excel sheets

#10

task3.xaml (14.3 KB)

#11

but after I pull different data, I want to collect Buil data and print it to exel last.

#12

@irem_dogan Yes it can

once you append data in excel, the next step uses a clear data table. Noe DT will empty, again it fetches data and append in excel then clear dt. the process will loop

#13

hi my friend sent the project

#14

@irem_dogan Give me few moments I m looking and then give you feedback

#15

thank you I am waiting

#16

Try this

Use Create Build data table with the same column
use merge datatable to append the values
Finally clear the Extract datatable
task3.xaml (14.1 KB)

#17

@irem_dogan So according to code, you want to get data but also maintain old one everytime

#18

yes i want to key all i got

#19

@irem_dogan Can I maintain Excel file

#20

first i want to move build by using add data latest excel