Hello,Please, I need dates to be in format day(dot)month(dot)(year).Examples: 23.12.2020, 18.05.2021 etcBut they can come in Excel files with multiple formats, example:
Translation DateDocument DateTax DateReversal Posting Date30/09/20209/30/202014-...
Hello, guys,Please, I get data from an Excel worksheet which might contain foreign characters.However, it is not recognized by BluePrism when I paste that data in SAP.I checked if BluePrism correctly reads the data from Excel, but I found out that th...
Hello and thank you for your attention.At my company, "import" is not allowed.We need to convert BP 6.8 pages to BP 6.0 without using Import tool.I know when you copy a page, it's actually a .xlm file, as below shows.
And when this same simple Page ...
@StefanSchnell1
Congratulations, very nice work!
I tought it was similar to AHK SAP ScreenReader, but it's more advanced!------------------------------Eduardo------------------------------
Hello, good day, @StefanSchnell1Would you kindly inform what is this program you are using to read SAP Script ID and Text?Thank you so much!Regards
------------------------------Eduardo------------------------------
I believe this is the best and fastest approach: select whole range and format it to desired DateFormat in a single action.Before, I was checking row-by-row if it is DateFormat.If it is DateFormat in Excel, change to dd.MM.yyyy.If it is a Text, then ...
Thank you, @shashank.kumar280 and @Michael ONeilFormat Cell can be used in Excel BO in BluePrism
Thank you everyone, it works, but the sheet is not recalculated and the new format does not appear until I save, close and reopen the file.(I need ...
