Excel Interop BC30574

[YoungFave]

BC30574 at line 14
Guys, can’t resolve this error. Need help

[prasath_S]

Hi @YoungFave

Please Try workbook.sheets(“Sheet1”)

Thanks

[YoungFave]

Now it’s “Cant convert from Object to Microsoft.Office.Interop.Excel.Worksheet”

[Srini84 (Srinivas Kadamati)]

@YoungFave

Welcome to fourms

Check below for your reference

HOWTO: Use MS Office COM interop with UiPath

HOWTO: Use MS Office COM interop with UiPath This tutorial is a step-by-step guide on how to use MS Office COM interop with UiPath. There are many questions on the forums on how to use the Microsoft Office COM interop with UiPath. People were looking for ways to use the Invoke Code activity along with the Microsoft.Office.Interop.Excel or Microsoft.Office.Interop.Outlook assemblies. Some people have been able to get it to work, but others have not been able to get it to work even when followin…

Hope this may help you

Thanks

[prasath_S]

Please give a try,

1. Click imports tab near arguments tab.

2. Type microsoft.office.interop.excel and import it.

Thanks

[YoungFave]

I have already done it

[prasath_S]

Hi @YoungFave give a try,

sheet = (Microsoft.office.interop.excel.worksheet)workbook.sheets(“Sheet1”)

Thanks

[YoungFave]

It’s hepled me: sheet = DirectCast(workbook.sheets(“Sheet1”), Worksheet)
But something is wrong in this line: excel = New Microsoft.Office.Interop.Excel.Application
Maybe because I don’t have excel license