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

Build
#1

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?

image
image4032×3024 3.63 MB
image
image4032×3024 3.51 MB

#3

Hi @Jagadesh2494,

Microsoft.Office.Interop.Excel.XlLookAt.xlWhole

XlLookAt is enum it inherits


Regards,
Omkar P
#4

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

#5

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

#6

image
image952×189 13.2 KB

#7

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

image
image1360×690 43.5 KB

#8

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

#9

Thanks it worked :slight_smile:

1 Like
#10

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