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 :
https://forum.uipath.com/t/copying-data-in-excel-and-replacing-in-word-document-using-uipath/421046/13

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.