Change the format of the Excel colums to text before writing to excel?

how can i Change the format of the Excel colums to text using uipath before writing to excel

1 Like

Add
“’” before that value in that column
ex
In For Each Row
Row(“ColumnText”)="’"+Row(“ColumnText”).Tostring

i have huge data to write and its not possible to use foreach row

Then Try to make it as text after writing it in Excel

Hi @LeelaGopinath,

The below package has an activity called “Change Cell Type” that to change format of the columns.

Regards
Balamurugan.S