Column type change1

Help Robot
,
1

Hi guys
I want to change column type and column values string to integer how i can do this?

2

can you elaborate

do you want to change the format in excel file or datatable ?

Regards

3

@Kuldeep_Pandey

Add a nee column of type integer and then use for loop and add the data to the new column or use the below expression in assign if all the column has data

Dt.Columns("NeeColumnName").Expression = "Convert([OldColName], 'System.Double')"

Then you can delete the old column wirh string values

Hope this helps

Cheers

4

Hi @Kuldeep_Pandey

You can add a new column with the TypeArgument Int32 & load all the from the string type column to this newly added column. (Given that every value in the string column is int convertible).

yourDt.Columns("newIntColumnName").Expression = "[oldStringColumnName]"

This will load all the data from the String type column to the Integer type column, thus changing the column’s data type.

Hope this helps,
Best Regards.

5

Yes i have column name as quantity in which i have many numbers data all are in string format i want to change those no as in interger format

6

If it is Datatable you can follow above approach provided by others

If it is excel then you can use format cells and provide the range of the column

Regards

7

Please provide me a xml for this

8

@Kuldeep_Pandey

There are only two activities you need to use add data column and assign activity…

Can you please try the same and let us know if any issues

Cheers