UIPATH How to copy CURRENCY from Excel and insert into Word Document

Help Studio
#1

If i formatted my excel cells as Currency, what variable type should i change the variable to? so that i can insert the currency from excel to word document with the currency symbols, decimal places etc.

1 Like
#2

Hey @audrxyx

When you read the same from Excel does it not giving you the currency symbols ?

Thanks
#nK

#3

Hi, i have tried saving it as a string and generic value but when i read from excel and replace in word document, it only gives me the number (e.g. 100) with no currency symbols

1 Like
#4

Hey @audrxyx

How are you reading it from Excel ?

Thanks
#nK

#5

Hi, currently reading from excel using a excel application scope, read range function, and get each current row in data table

1 Like
#6

Hey @audrxyx

That is where my query, in the data table are you getting the dollar currency symbol for the values ?

Thanks
#nK

#7

@audrxyx ,

I believe this Post is an Extension from the Below Post which already has the Solution :

#8

Hello @audrxyx ,

While reading the data from excel if $ is not present, can you append $ to the value which you are getting from the Excel and use Bookmark feature and word activities to write to Word document.