Select excel column in excel

[Ananya1 (a)]

i want to select whole column V ,
i used click image for V column, but its unable to find V Column as its in extreme right that is why unable to use click image.

[lakshman (Ganta lakshman)]

@Ananya1

Do you want to read column V from excel file ?

[Ananya1 (a)]

i want to convert column V to number
so i used click image to select column V , then i navigate to data then text to column and so on.

[bcorrea (Bruno Correa)]

see if this helps you:

Excel - Format column to text before writing

@mohammedamaan, I don’t think we have activities to do that, but if you have few rows of data and (I hope you are trying to write a number into fields and they are converting to some other formats ), you can directly paste the values by appending “'” , I mean (') a single quote before the data so that it will write as it is. If you have huge data, or anyway you want to change the format and you want to write the values, here is a piece of code which will help you in changing the formats Di…

[balupad14 (Balamurugan)]

Hi @Ananya1,

Here I have attached the sample file that how to convert column(V) to number.
Ananya1.zip (26.3 KB)

In Cell Format property you can able to specify the below format which in the excel format.

I have used the below package.

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
Balamurugan.S