How to resolve Excel error using Uipath

[Prafull_B (Praf)]

as per below screenshot I am getting error in excel as in green triangle in every cell
I need those data in numbers format.
Any help ?

[Palaniyappan (Palaniyappan P)]

Fine
Hope these steps would help you resolve this
—use excel application scope and pass the file path of excel as input
—inside the scope use a read range activity and and get the output with a variable of type datatable named dt
—next use a assign activity and mention like this
dt.Columns(“Yourcolumnname”).ColumnName=GetType(System.Int32)

This would convert that whole column to integer

Cheers @Prafull_B

[Prafull_B (Praf)]

I used this same approach but I got error as shown below

[Natapong (Natapong Raojutitam)]

@Prafull_B

Please try this

csvDT.Columns("Bears").DataType = GetType(System.Int16)

For reference:

Help: Change column Datatype

Hello @Daemo Hope this help ClonedTable.Columns["Post. Date"].DataType = GetType(System.DateTime) Regards

I hope it would be help you

[Prafull_B (Praf)]

Thank you so much @Natapong

that worked

any idea how to do the same operation on all columns

[KarthikBallary]

I too have same issue. but for write range activity.