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)

@Senthilkumar55

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.
Thanks!

2 Likes

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.

Hello!

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.

Best,
Peter