Convert String To Int in DataTable

Hi @rangga.waskita

Please try below steps,

Read the excel sheet data or use build datatable and store the data in the datatable variable name dt.

Drag and drop the invoke code activity.

In edit arguments, create a variable dt, set direction as in/out and pass value as dt.

In edit code type the following,

dt.asenumerable.tolist.foreach(sub(row) row(“Yourcolumnname”)= cint(row(“Yourcolumnname”)))

Write the datatable back into the excel using write range activity.

Or

We can use balareva activity to change the datatable column format, here is the reference for the same.

Hope this helps.

Thanks

2 Likes