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

Help
, ,
1

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

1 Like
2

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

1 Like
3

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

4

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

5

Hi @LeelaGopinath,

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

Regards
Balamurugan.S

6

@balupad14 How to change the cell type to “Text”. I tried by typing “Text” in the cell format field of “Change cell type” activity. But no luvk.

1 Like
7

Hi @suvalakshmi.e38,

to change it to text format . You have use the “@” symbol in the cell format.

Thank you
Balamurugan.S

8

Hi @balupad14 Thank you so much for your help that works.

Is there any activity to over write that text formatted cell. Because, I need the cell to contain the value as “Jan1” but by default the excel converts it as “01-Jan” so when I convert into Text data type it changes the cell with the value as “43831”. To have that field as “JAN1”, I need to override that same text converted cell.

1 Like
9

can u plz explain in detail on this

10

Hi @suvalakshmi.e38 ,

I think , you can use the same change format. Here you can more format.

Regards
Balamurugan.S