Convert unknown format to number in excel

[Sujith_Reddy]

Hi everyone,

I am getting an error in my excel sheet due to a format mismatch in a column, I wanted to convert this entire column to number format. Can you please help me with a solution on this?

[Gokul001 (Gokul Balaji)]

Hi @Sujith_Reddy

Check out the thread

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…

Hope it will helps

Regards
Gokul

[ushu (Usha kiranmai)]

Hi @Sujith_Reddy

Welcome to UiPath community. Have a look on the below one

UiPath | How to change the cell or column format in Excel | Guide (datatype)

[Rahul_Unnikrishnan]

Hello @Sujith_Reddy

Welcome to UiPath community.

You can use Format cells activity to achieve the same. Else another approach is to use a Excel Template with the required formats and write your data to that Template in each execution to keep the formatting.

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

Thanks