Preserve format currency issue

Help Activities
, ,
1

Hi ,
Trying to read currency value from excel . Using preserve format. The data is read as 2.95_) for currency value $2.95. why "_) " is getting added when preserve format is used. what could be the root cause

2

Hi,

What activity are you using? It may be better to use activity which is used inside UseExcelFile or ExcelApplciationScope. (not Workbook activities).

Regards,

3
  1. Use Read Range workbook activity to read the data from excel
  2. assign the output to a datatable in the properties of Read Range workbook
  3. Use For Each Row in Data Table activity to loop through the rows of dt
  4. Get the column value using CurrentRow.Item(“columnName”).ToString
    If it did not fix the issue try string manipulations yourStr.Substring (0,yourStr.Length-1)