Convert excel file

Learning Hub Academy Feedback
1

I want to create an excel file from datatable but when i create excel some column value change. like
001.0 change to 1
002.0 change to 2… please help me how to get actual format in excel

2

Hi
Welcome to uipath community
Let’s take like we have these values in a column A
So before writing that to a excel file
—use a for each row loop and pass the datatable as input to it
—inside the loop use a assign activity like this
row(“yourcolumnname”) = “‘“ + row(“yourcolumnname”).ToString

This will concatenated a single quote in front of all the values (‘0.002) which will not the let the excel to convert those rather keep them as text

Then followed by this use a write range activity

Hope this would help you
Cheers @rakeshghosh