Hey everyone, good morning. I’m trying to create a robot that extracts data from a website called “ADRES” to look up people’s ID numbers, the type of health insurance provider they have, and the city where they live. I want all this information to be added to an Excel file, organized by user. When creating the bot, I set up the sequence to open the Excel file and create a loop to read the ID number. Then I use Type Into and configure the browser settings. But when I get to the GET activities to copy the data into my Excel table, I get an error saying the data can’t be copied. I don’t know what I’m doing wrong. I’ve changed the delay times because the page is a bit slow, and I want to give it time to load the table so I can extract the data, but even that hasn’t fixed it.
Are you able to please show us your workflow and what activity are you using to perform the copy to excel?
We will then be able to help you better.
Always wait for the UI state, not for time. Use Check App State to check for the required element, then extract the data.
For web tables, Extract Table Data > Get Text.
Also, don’t use delays statically, you can increase timeouts based on the requirement.
I’ll use Extract Table and let you know how it goes.
You dont need for each row ..why do you want to write the same adata in multiple rows
you should i deally use write cell activity to write the data
cheers
Hi @Yeferson_Rivera,
For the webpage to wait, you can always use check app state and then use Extract table for web tables which will output a Datatable and to save the results in Excel just use write Datatable to Excel.
Hope this helps you
Regards,
Srini
sf IsNot Nothing AndAlso sf.Any(Function(x) Not String.IsNullOrWhiteSpace(x)) AndAlso sf.Any(Function(x) Not String.IsNullOrWhiteSpace(x) AndAlso targetStr.Contains(x))
