Indicate in Excel is throwing 0x80004023 error {00024500-0000-0000-C000-000000000046}

Feedback StudioX
, ,
1

image
23.10.0-beta.14233+Branch.release-v23.10.0.Sha.ac7649967f9e6f52cbf2d0156de91bd14e15f5cf

통합 문서를 여는 동안 오류가 발생했습니다. Excel이 설치된 경우 홈 화면의 도구 탭에서 'Microsoft Office Interop용 복구 도구’를 실행하십시오.

오류: System.Exception: 통합 문서를 여는 동안 오류가 발생했습니다. Excel이 설치된 경우 홈 화면의 도구 탭에서 'Microsoft Office Interop용 복구 도구’를 실행하십시오.
—> System.Exception: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80004023 Microsoft 소프트웨어 설치 프로그램 오류가 발생했습니다. (0x80004023).
at System.RuntimeTypeHandle.AllocateComObject(Void* pClassFactory)
at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean wrapExceptions)
at UiPath.Excel.Helpers.ExcelInteropHelpers.GetNewComApplication()
— End of inner exception stack trace —
at UiPath.Excel.Activities.Design.Services.ExcelWorkbookService.<>c__DisplayClass3_1.b__1(Object )
at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler), HResult -2146233088

What should I do? I’ve tried several treats but failed to solve the problem.

3

Hi @doglikecat41 ,
Can you share your file?
I think it’s too large
regards,

4

Project_Notebook.xlsx (39.7 KB)

5

Hi @doglikecat41 ,
I have tested it, I can read all sheet normally
what’s sheet you have error?
You can check your excel application in your PC, if it have problem, you can use read by workbook

image
image1508×881 50.5 KB

Sequence.xaml (10.2 KB)
regards,

6

7

Hi @doglikecat41 ,
in that is your file path
image
you can type in here file path or define path as string
image
or
image

regards

8

Hello,

I saw that you are using 23.10.0-beta.14233 and one has to ask what version of Excel are you running ? Also can you upload the logs ?

From previous experiences usually com issues arise when you have / had multiple excel versions installed and the registries get messed up . One way to mitigate this is to run the repair tool for MS Office ( Tools → Apps in the menu)

Also from what I saw the indicate in excel is not working :smiley:

Regards,
Dragos

9

Hi @doglikecat41 ,

Just wanted to check in here and see if we can get more information that would help us troubleshoot this. We’d be interested in the items below:

  • Excel package version
  • Logs
  • Check if you had multiple Excel versions
  • Whether you ran the Office tool

Many thanks,
Raluca

10

Hi @doglikecat41 ,

Just wanted to check in here if you had a chance to look into the additional info required for us to investigate this further. These would help us understand the issues better:

  • Do you have multiple Excel versions installed on the machine?
  • What version Excel package are you using in UiPath Studio?
  • Any additional logs
  • Whether you were able to run the Excel repair tool

Many thanks,
Raluca