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?

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

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

@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

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

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)

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

Add data and data scraping

Help Studio

raja.arslankhan (Raja Muhammad Arslan khan) September 15, 2022, 3:42pm 29

@Yurdanur_Yusuf I am not getting your problem, but I have same thread for you. look it

Topic		Replies	Views
How to put the ExtractDataTable in Add Data Row Activities datatable , uiautomation , activities , system	1	766	March 16, 2021
Appending data into Data table Activities datatable , activities , question , system	26	7103	May 21, 2022
Adding column to Data Table after Data Scraping Studio excel , activities , system	9	1850	April 8, 2022
Agregar filas a data table con variables Ask in Your Language activities	13	9087	July 30, 2019
Get row item after extracting from data scraping Help datatable , uiautomation , activities , studio , system	20	6228	February 16, 2019

Add data and data scraping

Related topics