Excel column format change

Hi All,

While adding values to excel column , after successfully run the bot , in result column i am not able to see result which is of number format, because that column default format is Date.

So how can we change or set column format using Uipath.
Please help…

1 Like

Hi @SagarSB,
Try this sequence.
Change column format.zip (6.8 KB)


I will try and let you know

wanna know if there is any update in this? tks!

Can you please try ChangeFormat activity from https://go.uipath.com/component/excel-extension-activities and let me know if this helps.


How can I format the entire row or column or sheet?

Use Select range activity followed by change format activty.

@Bharat_Kumar, This is only formatting cell “G1” and not the entire column.


I’m late to the party here, but I have found that using WriteRange rather than ExcelWriteRange preserves leading 0’s as the column in Excel is treated as text rather than a number.

Of course, this means you have to write the spreadsheet outside of an Excel Application Scope.


1 Like

@Inspiringtec If I want use column name in range. (Column name = Other)

How to write it?