Action is ambiguous,imported from the namespaces or types 'microsoft.office.interop.excel,system

Help Studio
1

Hi Everyone,

We recently migrated our project from Legacy to Windows. and i have encountered with this error

The image shows a UiPath Studio screenshot with an error message stating "'Action' is ambiguous, imported from the namespaces or types 'Microsoft.Office.Interop.Excel, System'," alongside a list of imported namespaces. (Captioned by AI)
The image shows a UiPath Studio screenshot with an error message stating "'Action' is ambiguous, imported from the namespaces or types 'Microsoft.Office.Interop.Excel, System'," alongside a list of imported namespaces. (Captioned by AI)1369Ă—575 34.2 KB

Thank you!

2

@Farooq_Syeda,

Please share Save to and value to save field code here to see what we can do to fix it.

3

This is the value @ashokkarale
If(dt_CSCSiteActivationData.AsEnumerable().Where(Function(e) e(“Site ID”).ToString.Trim.ToLower.StartsWith(Dict_Config(“PediatricMainCohortShortForm”).ToString.Trim.ToLower)).ToList.Count>0,dt_CSCSiteActivationData.AsEnumerable().Where(Function(e) e(“Site ID”).ToString.Trim.ToLower.StartsWith(Dict_Config(“PediatricMainCohortShortForm”).ToString.Trim.ToLower)).CopyToDataTable(),dt_CSCSiteActivationData.Clone)

4

@Farooq_Syeda,

This is for the value. Please share to which logic it’s being assigned.

5

The image shows an Expression Editor window in a software application with the variable "dt_CSCSiteActivationData" being edited. (Captioned by AI)
The image shows an Expression Editor window in a software application with the variable "dt_CSCSiteActivationData" being edited. (Captioned by AI)901Ă—570 27 KB

6

@Farooq_Syeda,

Ok it’s just a datatable. Do you have excel process scope in current workflow where this error is coming?

Try deleting this Microsoft.Office.Interop.Excel namespace from Import panel.

8

It Worked Thank you so much

1 Like
9

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