iRPA: Get Values (Cells) changes the value of the cell

[geigerp]

Hello,

I am copying values from an excel sheet into another program using the "Get Cells (Values)" action from the excel package. For some reason it changes commas into point for decimal values.

I.e. 150,02 becomes 150.02.

Thats a problem because the program I am pasting the values does not accept decimal values with a point, besides that this change isn't intentional.

Best regards,

Philipp

[vishal]

Hi geigerp,

Not sure about why Get Cell Values is behaving as such. Is it possible to store values in excel without comma format. Alternatively another quick workaround would be to suppress point/period "." values before they get picked up by the program

Can use below JavaScript code (within Custom Script Activity)

// in general
string.replace('characterToReplace', '');  

// to delete period value
string.replace('.', ''); 

Regards,

Vishal Rathi

[geigerp]

Thank you for your quick answer. Unfortunately it must have this comma.

I am already using the custom script activity how you suggested it, as I am familiar with JavaScript. The problem here is,

that the function/the activity constantly return null.

Best regards,

Philipp