Unable to find Microsoft.Office.Interop.Excel package in manage pacakges

Help Studio
, , ,
1

I am trying to use invoke code activity for some Excel operations but I am not able to find microsoft.office.interop.excel package.
Studio version using - 2022.10.7.

Kindly help asap. Thanks in advance.

2

Hi @Swetha_V

It will be available in the import panel please check.

Regards

3

@Swetha_V,

Check if Excel application is installed and UiPath.Excel.Activities package is installed.

Thanks,
Ashok :slight_smile:

4

Yes, i did checked and imported those.
But when I am t
Writing code to open it read the password protected Excel file, i am getting below error

Error BC30002 The Excel.apication is not defined and also Excel.workbook not defined.

5

Hi, yes installed al these.

6

@Swetha_V,

Ok. Can you share the code you are trying to Invoke?

7

To read or open password protected Excel file

Dim Excel app as New Excel.Application
Dim workbook As Excel.workbook = excelapp.workbooks.open(“path”, Password:=“password”)

my requirement is - I have to perform the sheet format in Excel or xlsm file like below

17216452408135169353924380531928
172164524081351693539243805319281920×1080 236 KB

17216453139994719376748756021697
172164531399947193767487560216971920×3413 1.34 MB

Note - in this we have to check if tab and semicolon checked or unchecked. If not we have to check, but at the end these two be checked.

8

Can anyone help here?

9

@Swetha_V,

I think issue is in declaration.

image
image777×99 10.8 KB

There should not be space between variable name.

Try removing the space and use like Excelapp

Thanks,
Ashok :slight_smile: