Skip to Content
1
Jul 16, 2020 at 01:20 PM

SAP IRPA - Problems with date formatting when copying from Excel

465 Views

Hello, I am currently working on a process that reads data from an Excel and later inserts the values into the appropriate fields of a SAP transaction.

However, the following problem occurs. Due to a custom format the "get" and "insert" function is not simply copying the string. Instead the values had been changed during the activity. As a consequence the required format is not met anymore.The cell formating of the excel file is set as it is and cannot be changed.


Here is a cell from the Excel file:

(DD.MM.YYYY HH:MM:SS)

Here's what I see in the log:

The same problem occurs with a number divided by a comma e.g. "1,3", which is saved with a dot (1.3) and then no longer matches the required formatting for the transaction as well.

Is there an option to copy and paste the values in a way that they match the string displayed in the excel file?

Thank you for your help!

Best regards

Karl

Attachments

5momc.jpeg (2.1 kB)
v4lax.jpeg (2.4 kB)