Change excel data format

[Allison_Cruz]

Hi! I need to change excel data format to Text for all the columns contained except for 1 column which name is sotored in a variable “FieldWithTheAmount” which type is Accounting and needs to remain like that.
How can I achieve that?
Best regards

[Palaniyappan (Forum Leader)]

Hi

Have a view on this custom component from UiPath market place

For changing the column format in a excel

UiPathGo - BalaReva Excel Activities

Hello Friends, I have successfully uploaded the BalaReva XL Activities in UiPath Go. This package contains 36 custom activities. It is related to the Workbook, worksheet and sheet data. It helps and simplifies more processes into the excel file. All components can be configured very user friendly. https://go.uipath.com/component/balareva-xl-activities This package is having the below activities. Pie Chart - Using these activities you can able to generate the Pie Chart Column Chart - Using…

Cheers @Allison_Cruz

[Srini84 (Srinivas)]

@Allison_Cruz

You can try BalaReva activities

Else you can maintain a template and define the Format as your required i.e., Accounting

Now when you are trying to write Range then use copy that template and write Range to that Copied template

Hope this may help you

Thanks