Convert the data type of column of datatable

[Ritika_Singh]

I have an excel sheet with multiple columns. I am using Read Range Activity and the data table automatically picks a column type as double which is having both number and string values .
I want to convert that Column from Double to String. I don’t want to use any custom activity .
Please help.

[Ritika_Singh]

Hi @Yoichi ,

Any help from your end would be really appreciated

[ImPratham45 (Prathamesh Patil)]

Try using enabling PRESERVE FORMAT property in Read Range activity and then try.

[rahulsharma]

@Ritika_Singh

want to convert that Column from Double to String. I

@balupad14 got it covered

UiPath Marketplace - BalaReva Easy Data Table Activities

Hi , I have uploaded a package called “Easy DataTable Activities” in UiPath Marketplace. The package contains the below activities. Change Column Data Type - Change the datatype for DataTable by having the option to multiple columns Dictionary To DataTable - Convert the dictionary to DataTable Show DataTable - This activity helps to see the DataTable value and column information. Mainly this is testing DataTable value in the development stage. Here is the video explanation for the p…

[Yoichi]

Hi,

I suppose type of Datacolumn is object if use ReadRange ativity…
Anyway, we cannot change type of DataColumn if data already exists.
The following sample is for create new datatable which has same name columns and expected data type.

Sample20211027-1.zip (8.9 KB)

If your datatable is very large, it might be better to write the above in InvokeCode.

Regards,

[Ritika_Singh]

Can I create a new data table with all columns as required type and then read the excel to avoid this issue

[Yoichi]

Hi,

@Ritika_Singh

Can I create a new data table with all columns as required type and then read the excel to avoid this issue

We can create datatable which has any type column. However ReadRange activity overwrite datatable schema when write data into it. So probably it won’t be solution.

Regards,

[Ritika_Singh]

My data table has more than 1 lakh of data , i am using for each but it is not feasible, I am using below invoke code but it is not working
newDt = dt.Select(Function(o) o.ToString).CopyToDataTable

Please can you check once

[Yoichi]

Hi,

How about the following?

For Each row As DataRow In dt.AsEnumerable
newDt.Rows.Add(row.ItemArray.Select(Function(o) o.ToString).ToArray)
Next

Sequence.xaml (8.2 KB)

Regards,

[Lakshay_Verma]

How to convert Data Type of Columns using LINQ in a DataTable?

You can try this in an invoke code, of course with in and out arguments. Here the requested data is in column 3: 'Create a copy of the original table Dim TableDummy As DataTable=in_CODE_Table.Clone 'Run a LINQ-query with grouping and load a datarow in order to return a datatable out_CODE_Result=(From row In in_CODE_Table.AsEnumerable() Select TableDummy.LoadDataRow(New Object() {row.item(0).ToString, row.item(1).ToString, row.item(2).ToString, Convert.ToDouble(row.Item(3).ToString)},False)).Cop…