Excel column format change

[SagarSB]

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…

[Senthilkumar55 (Senthilkumar V)]

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

[SagarSB]

@Senthilkumar55

I will try and let you know

[yunglinchang]

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

[Bharat_Kumar]

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

[mohammedamaan]

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

[Bharat_Kumar]

Use Select range activity followed by change format activty.

[Inspiringtec]

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

[hbpe (Peter Hansen)]

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

[fairymemay (noona)]

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

How to write it?