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?
Welcome to Uipath community
If you need to handle this error.
You can try with
extractDataTable .Rows.Count>=1 in the If activity.
@irem_dogan can you show me how you are adding data in datatable
I’m pulling data with data scraping
@irem_dogan can you show me ExtractDataTable type.
why you are not using arrayrow?
I tried because I didn’t know how to use it, but I couldn’t find how to convert the data.
@irem_dogan give me code I can adjust
By using this method you can add row by row only
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
task3.xaml (14.3 KB)
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
hi my friend sent the project
@irem_dogan Give me few moments I m looking and then give you feedback
thank you I am waiting
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
yes i want to key all i got
@irem_dogan Can I maintain Excel file
first i want to move build by using add data latest excel