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…
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.
Thanks!
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
@Inspiringtec If I want use column name in range. (Column name = Other)
How to write it?
