UiPath Reading Excel Cell Value with Wrong Currency Symbol

Help Studio
, , , , , ,
1

Good Morning!
I am trying to develop a process which is reading specific cells from Excel with a currency value.

The value I am trying to read is using the GBP symbol ‘£’
However, when UiPath reads the cell the value returned is displaying the ‘$’ dollar symbol.

It works okay on my local machine but not on the unattended machines. The date/time/region settings seems to all be the same on both machines and I am still seeing the issue. The cells are set to the currency format within Excel and we are using the Modern Read Cell activity in UiPath
Thanks

2

Hi @elliot.barling

Can you try with below properties

An automated process to read and format data from an Excel file "Input.xlsx" while saving a specific cell value from Sheet1. (Captioned by AI)
An automated process to read and format data from an Excel file "Input.xlsx" while saving a specific cell value from Sheet1. (Captioned by AI)703×634 22.7 KB

Or

UiPath Studio workflow reads a cell from an Excel workbook with specified file path, sheet name, and cell address. (Captioned by AI)
UiPath Studio workflow reads a cell from an Excel workbook with specified file path, sheet name, and cell address. (Captioned by AI)1381×658 32.4 KB

Regards,

1 Like
3

Hey @elliot.barling
if working this can you try to enable this option and then check the value.

A screenshot depicting a configuration window for reading a cell value in a software application, highlighting options such as "Cell," "Save to," and "Get formatted text" with the latter checked. (Captioned by AI)
A screenshot depicting a configuration window for reading a cell value in a software application, highlighting options such as "Cell," "Save to," and "Get formatted text" with the latter checked. (Captioned by AI)1036×215 13.9 KB

and if you are working with classic

The image shows a UiPath workflow where a value is read from cell A1 in Sheet1 and assigned to 'strInout' before being written out. (Captioned by AI)
The image shows a UiPath workflow where a value is read from cell A1 in Sheet1 and assigned to 'strInout' before being written out. (Captioned by AI)982×312 20.8 KB

then enable this option

cheers

4

Hi @elliot.barling

Check the regional settings on the unattended machine to ensure the currency symbol is set to £. Pls set the Read Cell activity’s output type to String. After reading the cell, use
Convert.ToDecimal(ReadCellOutput).ToString(“C”, New System.Globalization.CultureInfo(“en-GB”))
to format the value as GBP. Ensure that Excel cells are set to Currency (GBP) format. Finally, confirm that the UiPath robot settings match the regional settings of your machine.

If you found helpful, feel free to tick as a solution.
Happy Automation