Error BC30512: Option Strict On disallows implicit conversions from 'DataTable' to 'IEnumerable'. The selected value is incompatible with the property type

Help Studio
, , , ,
1

While practicing Simple Excel Automation, Read two Excel worksheets in to two datatables, and added ForEach Activity and added the dt_<> in to the List of Items. But getting the below error:

I even tried upgrading/downgrading Systems.Activites Packages, but didn’t work. Referred to this also:

The image shows a UiPath workflow with a "For Each" activity that has encountered a compiler error due to the implicit conversion issue from 'DataTable' to 'IEnumerable' with Option Strict On. (Captioned by AI)
The image shows a UiPath workflow with a "For Each" activity that has encountered a compiler error due to the implicit conversion issue from 'DataTable' to 'IEnumerable' with Option Strict On. (Captioned by AI)693×401 56.4 KB

2

Hi Pavan.

If you are working with data tables. Please use For each row in data table activity.
image

3

@pavan00kalyan,

To iterate datatable rows we have dedicated activity that’s For each row in datatable. Use this instead of For Each activity.

4

Thank you , It worked

5

Thank you , it worked.

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.