Change the cell format as number

[Aarthy1 (Aarthy)]

Hi guys
I want to convert the column format as number
In 1st
photo ‘F’ column the cell format is in text
In 2nd photo ’ F’ column cell is converted into number

I need this thing in uipath. Please help me to solve this

1 St photo →

2nd->

[Ahmad_Rais (Ahmad)]

HI

You can achive this using balaReva excel activities

UiPathGo - BalaReva Excel Activities

Hello Friends, I have successfully uploaded the BalaReva XL Activities in UiPath Go. This package contains 36 custom activities. It is related to the Workbook, worksheet and sheet data. It helps and simplifies more processes into the excel file. All components can be configured very user friendly. https://go.uipath.com/component/balareva-xl-activities This package is having the below activities. Pie Chart - Using these activities you can able to generate the Pie Chart Column Chart - Using…

heres for your reference

regards
ahmad

[raja.arslankhan (Raja Muhammad Arslan khan)]

Hi @Aarthy1
Try this one.

UiPath | Format Numbers In Excel Column with VB.NET | How to set Number formet to Excel Column

[Rahul_Unnikrishnan]

Hello @Aarthy1

You can use the Format cell activity to modify the format.

Else you can keep a Excel Template with the required formats and then do write range to that template.

UiPath - Set Cell Color, Alignment, Font Style | Format Cell Activity |UiPath Tutorial

Thanks

[Aarthy1 (Aarthy)]

Belarava activity is working for me

[Ahmad_Rais (Ahmad)]

great !
please mark it as " SOLUTION "

so other can refer to the answer

thank you
Ahmad

[Aarthy1 (Aarthy)]

Sorry bela re a activity is not working for me

[Gokul001 (Gokul Balaji)]

Duplicate : Change the excel cell in text format to number formate - #3

[Aarthy1 (Aarthy)]

Hi

I need to change the cell format as text to number in uipath
In 1st photo ‘F’ Column is in text formate

I need ‘F’ Column change as in number format like this

Please say some solution of this

[Tapan_Behera1 (Tapan Behera)]

Hi @Aarthy1 you can select F columns then go to number group—>click general drop down —> and select numbers to make the columns format text to number.

[raja.arslankhan (Raja Muhammad Arslan khan)]

Hi @Aarthy1
Try this one through invoke code.

UiPath | Format Numbers In Excel Column with VB.NET | How to set Number formet to Excel Column

[Rahul_Unnikrishnan]

@Aarthy1

Duplicate post :

Change the cell format as number

Hi guys I want to convert the column format as number In 1st photo ‘F’ column the cell format is in text In 2nd photo ’ F’ column cell is converted into number I need this thing in uipath. Please help me to solve this 1 St photo → [IMG_20220929_072625_758] 2nd-> [2nd]

Thanks

[Gokul001 (Gokul Balaji)]

HI @Aarthy1

Check out this

UiPathGo - BalaReva Excel Activities

Hello Friends, I have successfully uploaded the BalaReva XL Activities in UiPath Go. This package contains 36 custom activities. It is related to the Workbook, worksheet and sheet data. It helps and simplifies more processes into the excel file. All components can be configured very user friendly. https://go.uipath.com/component/balareva-xl-activities This package is having the below activities. Pie Chart - Using these activities you can able to generate the Pie Chart Column Chart - Using…

Regards
Gokul

[Aarthy1 (Aarthy)]

Hi

Bela rava activity is not work for me

[loginerror (Maciej Kuźmicz)]

I merged two duplicate topics into the earlier one.