Error while adding the scraped data to a database(using UiPath)


I am trying to store the data in a database(using UiPath) after data scraping all the data from a website but getting an error in “Add Data Row”.

I am not able to solve the error because it always says “index was out of range. Check that the collection has values and the index is less than the size of the collection”. “IndexOutOfRange” exception.

terrorism.xlsx (15.1 KB)
Main.xaml (17.6 KB)

Can anyone please help me with this?

I am attaching my xaml and excel file for reference.


in read range “terrorism.xlsx” give range as “” instead of “A1:A2”.

Thankyou @kirti.iyer. It worked.

But now I am getting some other error and that is
Source: Insert
Dynamic SQL generation is not supported against a SelectCommand that does not return any base table information.
ExceptionType: InvalidOperationException

Can anyone help me with this?

Thanksterrorism.xlsx (15.1 KB)
Main.xaml (17.8 KB)