Dear RPA experts, I have a column of csv file that should be changed to number type when it is written to Excel. What is the best way to do this? I tried many ways but i did not come to the right solution. Many thanks for your help. Regards, Nazarius

Converting a column in csv file from string type to number type

balupad14 (Balamurugan) October 16, 2019, 9:19pm 12

Here is an activity to convert the csv to excel and you can able the change the column datatype. And it has video explanation also.

Regards
Balamurugan.S

Topic		Replies	Views
CSV Column Format Change Studio datatable , excel , uiautomation , activities , studio , question , activities_panel	10	470	October 30, 2023
Column type change1 Robot robot , question	7	307	May 15, 2023
Write column on csv to excel as number not a text Academy Feedback datatable , excel , csv	1	968	January 27, 2020
Covert Datatable Column from character to numeric Activities excel , activities , question	19	1563	January 23, 2022
How to change the data type of a column in data table Random and other categories activities	3	10725	June 24, 2019