How to resolve Excel error using Uipath

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 ?

1 Like

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

1 Like

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

screen3

@Prafull_B

Please try this

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

For reference:


I hope it would be help you :blush:

1 Like

Thank you so much @Natapong

that worked

any idea how to do the same operation on all columns

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