Error while using open Application scope

Using Ms Office 2010 pro
Error Stated:
Source: Excel Application Scope

Message: Error opening workbook. Make sure Excel is installed.

Exception Type: System.Exception

An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is:
System.Exception: Error opening workbook. Make sure Excel is installed. ----> System.InvalidCastException: Unable to cast COM object of type ‘Microsoft.Office.Interop.Excel.ApplicationClass’ to interface type ‘Microsoft.Office.Interop.Excel._Application’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{000208D5-0000-0000-C000-000000000046}’ failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).
at System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)
at Microsoft.Office.Interop.Excel.ApplicationClass.set_SheetsInNewWorkbook(Int32 RHS)
at UiPath.Excel.WorkbookApplication.StartNewApplication()
— End of inner ExceptionDetail stack trace —
at UiPath.Excel.WorkbookApplication.StartNewApplication()
at UiPath.Excel.WorkbookApplication.InitializeExcelApp()
at UiPath.Excel.Activities.ExcelApplicationScope.<>c.<.ctor>b__44_0(WorkbookArguments args)
at UiPath.Excel.Activities.ExcelApplicationScope.Execute(NativeActivityContext context)
at System.Activities.NativeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

Goto Manage Package and Install UiPath.Excel.Activities Package

I CANNOT USE EXCEL APPLICATION SCOPE WITHOUT INSTALLING UIPATH.EXCEL.ACTIVITIES

IT COMES INSTALLED IN NEW UIPATH STUDIO VERSIONS
i have tried reinstalling Ms Office 2010 pro as well as UiPath
But Same Problem.
So i Cant Use excel App integration,But system integration works fine for me.

Hi @KartikPurohit

Try this activity.

Regards,
Ranjith
Read Range work book

If you are facing this error , please check the shared link where the same issue has been resolved.
Link Error opening workbook. Make sure Excel is installed - #6 by Affster

Sir, without Excel app scope it will not work.
So,I Have To use Read Range under System Integration.

@KartikPurohit,

Use Workbook read range activity. For this no need of Excel application to be installed in your system.
image

Regards,
Lakshman Ganta.

1 Like

I am Using This Only But What If I Want Sort Table.

For this, we need excel application to be installed in it and then only we can use it.

If you want to sort DataTable then you can use Sort Data Table activity.

Regards,
Lakshman Ganta.

So we can use Sort table without using Excel App Scope.

@KartikPurohit,

Sort table and Sort Data Table both are different.

First take workbook read range activity to read Excel data and it will give you output as data table. Then you use sort Data Table activity. For this no need of Excel application to be installed.

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