Hi Team,
I have one excel and I want to chage the cell format general to text using UiPath or excel formals like vlooup or hlookup
Kindly suggest…
Please find the input and output exce
Thanks
Hi Team,
I have one excel and I want to chage the cell format general to text using UiPath or excel formals like vlooup or hlookup
Kindly suggest…
Please find the input and output exce
Thanks
Another Method @Baby123
You can also try with Format cell activity
Check out the the Tutorial
Range -> Excel.Sheet("Sheet1").Range("A1")
Regards
Gokul
Hi @Gokul001 ,
I want to change entire column at a time .
Is their any excel formula to change the format.
Please suggest
Hi @Gokul001 ,
Thank You,
But I don’t know knowledge on modern activities
So, can you please send the workflow.
Thanks in advance
Hi @Baby123
Go to → Activities Panel → Click on Filter → Select Show Modern.
Step 1 : Use Excel process scope followed by Use Excel file activities.
Step 2 : Use Format Cell Activity,
Check out the XAML file
FormatCellStudioX.xaml (8.5 KB)
Regards
Gokul
Hi @Gokul001 ,
I saw the workflow but after changing the format I want triangle shape in the left corner of the cell .
Please find the attachment below.
After changing the cell format as text I want to triangle shape also in each cell
Here one option is to use the Format cell activity. Another approach is , if your template is static, then you can create a Sample Excel Template with all the custom formats for each columns.
Then you can use Read range and write range to that particular template. I hope it can preserve the formats as required.
Thanks