October 19, 2022, 3:28pm
I have an activity which writes the current date to Excel cell.
The activity is: UiPath.Excel.Activities.ExcekWriteCell.
The value is: Now.ToString(“dd/MM/yyyy”)
It used to work fine, but recently UiPath displayed a message suggesting to convert the project from Windows Legacy to Windows, I converted but then that activity stopped working and it issues this error:
The message details are:
“message”: “Write Cell: Date: Expression Activity type ‘VisualBasicValue`1’ requires compilation in order to run. Please ensure that the workflow has been compiled.”,
My UiPath details:
Thank you very much for your help.
October 19, 2022, 3:31pm
Just Retry the Date in that activity. Issue is Double Quote
In windows legacy, it seems double quote is normalized and any double quote characer is accepted. However, at this time, in windows (.net6) ,in fact, only " (0x22) is accepted to express string literal. To make matter worse, it seems to occur only compiling. (Expression validator don’t raise an alert.)
FYI, the following is sample for reproducing. The first Assign uses " 0x42 and second Assign uses “ and it fails in compiling.
Sample20221013-2.zip (2.1 KB)
October 20, 2022, 5:37am
Without quotes it issues an error:
October 20, 2022, 5:38am
Use Double Quote in the Date Format
October 20, 2022, 5:40am
I tried (with and without quotes) but it issues an error:
October 20, 2022, 5:42am
Instead of Copy paste Type the Date format and Double Quote manually
Or Downgrade the package and check it
Today, use ToString. You are using Today in the expression instead of ToString.
October 20, 2022, 10:40am
I can’t check it because now I’m getting a new error regarding the ExcelApplicationScope itself:
I get too many issues since I accepted the UiPath suggestion to convert from Windows Legacy to Windows (one of them is a very prolonged compiling, like 15 minutes…).
Could you please advise and explain how can I revert my project to Windows Legacy?
October 20, 2022, 10:49am
Check out the thread
After creating a new project with the targetFramework of Windows, I am unable to copy its activities to a different project that uses the older Windows-legacy framework. I am also unable to invoke the new workflow from the Windows-legacy framework project.
How can I change the targetFramework back to Windows-legacy project?
I created a project as Windows compatibility and need to convert it to Windows-Legacy. Is there a tool/utility to do this? Rebuilding all my workflows by hand is going to take a long time.
Also, I’m using UIPath Community 2021.10.4
October 20, 2022, 10:53am
In the your project open the Project.JSON file and update it
October 26, 2022, 10:08am
Thank you, but this resulted in a bunch of errors, so I reverted it.
I’m still looking for a solution.
October 29, 2022, 4:29pm
The solution was to Update Dot Net version (from 4.6 to 6) and to Remove temporary files in UiPath system.
I think its the migration from windows legacy to windows.
October 31, 2022, 4:20am
That’s for sure, as I mentioned at the beginning.
Then can you confirm the dependent packages are updated to the latest version?
Is your Issue resolved after applying the Solution mentioned ? If so, Would request you to Close the Topic by marking your Post as the Solution.