Changing excel cell format with UiPath

Hi,
To change cell format , you can use the “ChangeCellType” activity which is existing in the blow link.

Regards
Balamurugan.S

3 Likes

Hi ,

I have this package but it done not have any activity . But it does not have any activity called “ChangeCellType”.

How should i use this activity.

Thanks,
Jelin

image

image

1 Like

Hi @jelin,
Check it here and use the latest version 2019.4.0…

Regards
Balamurugan

1 Like

Thanks… i Got it :slight_smile:

2 Likes

Thank you very much for your packages!

Your contribution has saved me a lot of time in my projects. :smile:

I wish you the very best and have a nice day :smile:

1 Like

Hi @ruh_hastasi77,
Thank you . Your wishes and comments make me to do more things…

Balamurugan.S

2 Likes

@balupad14 For me it is not working any idea?Please help me.

2 Likes

@balupad14 Got it thanks man it is doing wonder, If you are okay can you please share me the source code of that custom package

1 Like

Thank you @arunshiva

Are you have a example or screenshot for how to add value in the Properties ribbon the Change Cell Type Activity own?

I suggest you change the cell format by using VBNET code

HI @Brian_Henokh1,

May I know Why you want to use the properties which in Ribbon.

The format Cells has all the Properties which is in the above one

Regards
Balamurugan.S

Is there any documentation of the cell format parameter?

If I want to change the cell format as text, what should i set the cell format parameter?

Can you provide this coding which will help me currently to resolve an issue

Hi @cscrpa002,

Check this video…

Thank you
Balamurugan.S

How can I change from text to general???
What is format for that???

2 Likes

Hi
I am facing the same issue. Could you please help me with getting the cell value in number format.

To general have to do like below.

Regards
Balamurugan.S

1 Like

hi @cscrpa002,

Check this link.

Regards
Balamurugan.S

1 Like

Hi…
Could you please share VBA code you used for this?