Visual studio c# code not working in uipath invoke code activity

[Jagadesh2494 (Jagadesh)]

Hi,

I have written a c# code to find column header in excel which is working fine in visual studio but if i run the same code in uipath invoke code activity am facing error. I have also imported/installed (“Microsoft .office.interop.Excel”). Could someone please help me on this?

[Reddy_Paluri (Omkar Reddy)]

Hi @Jagadesh2494,

Microsoft.Office.Interop.Excel.XlLookAt.xlWhole

XlLookAt is enum it inherits

XlLookAt Enum (Microsoft.Office.Interop.Excel)

Regards,
Omkar P

[Jagadesh2494 (Jagadesh)]

Sorry I didnt get you, could you please elaborate? Or could tou please procide what code should be used there?

[Reddy_Paluri (Omkar Reddy)]

please show me 20 th line of your code in editor

put this below line before XlLookAt
Microsoft.Office.Interop.Excel

Microsoft.Office.Interop.Excel.XlLookAt

[Jagadesh2494 (Jagadesh)]

[Reddy_Paluri (Omkar Reddy)]

please try both ways
1)
In 22 line LookAt:Excel.XlLookAt.xlWhole remove and place Type:1
because it is enum typle
2)In 22 line LookAt:1

[Jagadesh2494 (Jagadesh)]

Thanks, i will try this and get back to you😊

[Jagadesh2494 (Jagadesh)]

Thanks it worked