About the bug: Retrieving value from excel having an issue
Scenario: Trying to read the config file value form excel. Value in excel contains formula
Steps to reproduce:
- Add a value in excel =“Emerging_Data_” & TEXT(TODAY(), “yyyymmdd”) & “.xls”
- save the excel.
2.Read the excel value into new dictionary as key value pairs.
- Display the value.
Result: File name in excel is different from file name displayed by uipath
Current Behavior: Wrong file name (Emerging_Data_20190018.xls) display by uipath i.e month value is not displaying properly
Expected Behavior:correct filename(Emerging_Data_20190518.xls) should be displayed
Version of the software with the bug:
Studio/Robot/Orchestrator Version: 2019.4.2/ Community edition
Activity Package Version (when relevant):
Sample process (packaged as a zip file): Attached
(workflow, logs, .net version, service pack, etc):
Welcome to uipath community buddy
you know something, you were almost right buddy just change this alone buddy
“Emerging_Data_” & TEXT(TODAY(), “yyyyMMdd”) & “.xls”
The reason is mm denotes minute and MM denote month
thats y buddy
Kindly try this and let know buddy whether this works or not
did that work buddy @Pavan_Gunda
Thanks Buddy it is working fine.
One thing i dint understand here is …in excel mm shows as current month and value is perfect. However, why it is treating as minutes while reading the value and displaying it from uipath.
This could help you buddy…
Format numbers as dates or times - Office Support
I dint see an option to close this thread. Can you please tell me how to close it
Buddy it will be there in left side of the like button in the comment buddy @Pavan_Gunda
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.