Excel - Currency Write Cell- Excel "number in this cell is formatted as text or preceded by an apostrophe"

Hello Team,

I have given excel where Excel Cells are made to accept currency . Cell E2 will be sum of I2:T2.

I am trying to write value into Excel using Write Cell.
image

But the issue is: after updating cells using UiPath Write Cell, it shows with “number in this cell is formatted as text or preceded by an apostrophe” and the Cell E2 will not consider that cell for SUM.
Once i double click on the cell and come out, it works fine.
I would like to directly update the cell without any such error.

Workaround i tried:
Sending value as Generic value
sending value as decimal
Sending value after formatting the value to currency.

Nothing above worked out for me. Someone kindly help!

Test.xlsx (85.1 KB)

excelwrite.xaml (3.8 KB)

@Palaniyappan, @HareeshMR, @aksh1yadav, @vishal.kp, @loginerror

2 Likes

Hi,
Are you sure that you are sending the values in the type of integer. The double quotes surrounding your number makes it a string. Just a suggestion. :slight_smile:

Just as you have E column as currency, make the I column as integer or number. so that the number you write with the activity will make it as a number @anon62075255

@HareeshMR They need to see I to T column with $ symbol only. Hence they need cell as Currency.

If i do manually entry to that cell, it takes as currency and E column sums it.

@vishal.kp
Excel accepts String or generic value. I tried sending as Generic value, that didnt help me as well.

Workaround i tried:
Sending value as Generic value
sending value as decimal
Sending value after formatting the value to currency.

You mean the columns I to T are of formats currency ? @anon62075255

Then it won’t take it as a string if you write value.

Yes, they are currency.
How do i write currency from UiPath so that i dont get below error

Sorry for the delayed response.

As write cell which you are using will take only string values and it will take the value as string and write it as string in excel

Can you try with excel application scope and write cell inside it @anon62075255

That will write as currency :slight_smile:

4 Likes

@HareeshMR, Thank you so much. Moving logic inside Excel scope is working.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.