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

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?

Hi @Jagadesh2494,

Microsoft.Office.Interop.Excel.XlLookAt.xlWhole

XlLookAt is enum it inherits


Regards,
Omkar P

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

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

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

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

Thanks it worked :slight_smile:

1 Like

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