Writing the current date to Excel cell

Help Studio
, ,
1

Hello everyone,

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”)

image

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:

image
image710×505 15.7 KB

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.”,
“level”: “Error”,
“logType”: “Default”,
“timeStamp”: “18:11:44”,
“fileName”: “FastSubmission”,
“processVersion”: “1.0.0”,
“jobId”: “2775c061-0ee3-4d7f-bef7-DELETED”,
“robotName”: “DELETED@gmail.com-attended”,
“machineId”: DELETED,
“organizationUnitId”: DELETED
}

My UiPath details:
image
image

Please advise.
Thank you very much for your help.

2

Hi @Udiar

Just Retry the Date in that activity. Issue is Double Quote "

Regards
Gokul

3

Just Like this @Udiar

Now.Today("dd/MM/yyyy")
4

Without quotes it issues an error:
image

5

HI @Udiar

Use Double Quote in the Date Format

Now.Tostring("dd/MM/yyyy")
6

I tried (with and without quotes) but it issues an error:
With quotes
image
Without quotes
image

7

Instead of Copy paste Type the Date format and Double Quote manually

Or Downgrade the package and check it @Udiar

Now.Tostring("dd/MM/yyyy")
8

Hello @Udiar

Instead of Today, use ToString. You are using Today in the expression instead of ToString.

Now.ToString(“MM/dd/yyyy”)

Thanks

9

I can’t check it because now I’m getting a new error regarding the ExcelApplicationScope itself:

image
image698×680 19.2 KB

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?

10

Check out the thread @Udiar

Regards
Gokul

11

In the your project open the Project.JSON file and update it @Udiar

“targetFramework”: “Legacy”

image

1 Like
12

Thank you, but this resulted in a bunch of errors, so I reverted it.
I’m still looking for a solution.

13

The solution was to Update Dot Net version (from 4.6 to 6) and to Remove temporary files in UiPath system.

14

I think its the migration from windows legacy to windows.

Thanks

15

That’s for sure, as I mentioned at the beginning.

16

@Udiar
Then can you confirm the dependent packages are updated to the latest version?

Thanks

17

@Udiar ,

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.