I need help with converting column data to numbers in excel with UIPath Studio

I need help with converting column data to numbers in excel with UiPath Studio.
The contents are as shown below.
I am new to UI Path so I apologize for the inconvenience. I appreciate your guidance.
image

Hie @lam_thanh_nguon for this you can read the data and after this use for each and inside use one assign activity and create variable of integer pass your data like this
Cint(currentrow("ColumnName)) and after this use write cell and increament the column so every time bot write the data into the next cell…
Cheers Happy Automation

@lam_thanh_nguon,

Use Format Cell Activity to format the column as number.

Thanks,
Ashok :slight_smile:

Thank you very much for your enthusiastic support. But is there any faster way? :))

Thanks for your guidance. I will try it right away.

1 Like