Write cell in a specefic format using workbook write cell activity

[abdel (Robot usa)]

Hello Friends,

I’m writing in an xlsx using a workbook write cell activity:

the result is :

and i want to put it under:

with thousand separator

[Palaniyappan (Forum Leader)]

Hi

Have a view on this thread for more ideas

I am looking for number format as per following 1200,00,000.00

Hi @kawalkarhemant and all members, I have created a custom activity to format the double and number values instead of using the code invoke. Using this activity you can able to format in any combination. It has 2 activities. One is for double value and another one is for integer. I Hope it will helpful . Below I have attached Thank you Balamurugan.S

Cheers @

[Yoichi]

Hi,

It seems difficult to write it as number format using Workbook-WriteCell activity.

One of workarounds is to use ClosedXML which is also used UiPath.Excel.activities.

The following is a simple sample to write value and set format.

Sample20211029-1.zip (8.7 KB)

Hope this helps you.

Regards,

[abdel (Robot usa)]

Thank you yoichi, did it need installation of Microsoft Office in machine s??

[Yoichi]

Hi,

No, you don’t need. ClosedXML is library which can handle OOXML format(xlsx eetc)and is used Workbook-ReadRange etc. We can access xlsx file via it without MS-Office.

Regards,

[abdel (Robot usa)]

Hello,

why the sample work in a stand alone test, but when i integrate it in the workflow it did not work?

[Yoichi]

Hi,

Can you share your xaml and excel file, if possible?

Regards,

[dokumentor (Gabriel Marin)]

You may format cell manually. Then the robot can write cell and format is kept