Change Cell Type: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154 Class not registered

Help Activities
, ,
1

Hi @balupad14

I am trying to add custom cell format i.e “mm:ss” for the “H: H” column. but getting below error

image
image1198×634 52.9 KB

this how my excel columns look like.
image

@balupad14 please let me know.

@loginerror
@Pablito
@Palaniyappan
please have a look into it and let me know.

2

Hey @balupad14
The same is working on a community license and not working enterprise license.

Thanks,

1 Like
3

hi @prashantP ,

Definitely, It will work in the enterprise version. Can you please share a sample project and what enterprise version that you are using?

Thank you
Balamurugan.S

4

@balupad14 thanks for the replay.

I can’t share the project file.
the enterprise studio version is 2020.4.1
image

Let me know if anything else we can do.
error log
change cell type.txt (862 Bytes)

Thanks
Prashant

5

Please let me know how to do it.

I want to change the excel column format.

let me know if there is any other way to do it?
@Pablito
@Palaniyappan

6

can you tell me the version of BalaReva.Excel package.

7

Here is
image

@balupad14

8

Hi @prashantP ,

Please check it that the activity should not be inside excel application scope from uipath…

9

Hi @prashantP ,

I tested both the enterprise and community . It is working well. Here I have attached the sample for you . Please test this in your enterprise version environment.

Before execution :

image

After execution :

image

Sample : Excel Change Cell Format.zip (72.2 KB)

Thank you
Balamurugan.S

10

thanks @balupad14

still it is not working on enterprise
image

is it mandatory to have MS office installed for this activity ?

11

Definitely. It should have the office installed. Does it have an office or not?

Regards
Balamurugan.S

12

then I apologies I was not aware.

we don’t have MS office on client machine.
@balupad14 is there any other way to do it without MS office installed? please let me know.

Thanks
Prashant

13

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