Hi,
I have excel file download to “EXPORT.xlsx”, i want to change that to "Daily Report - "+System.date.now.Tostring(“dd/mm/yyyy”).
Tried with Invoke Method, Invoke Code but can add “Daily Report” but not today’s date.
Please help
Hi @Sudhir_P
Please try Move file activity
https://docs.uipath.com/activities/docs/move-file
in source give the “yourfilepath/export.xlsx” file path, and in destination give the file name as
"Yourfilepath/Daily Report - " + now.Tostring(“dd/MM/yyyy”) + ".xlsx"
Thanks
tried that.
Move File:
From “C:\Users\sudhir.k\Documents\UiPath\Generation_and_Circulation _of _IQC _Daily_MIS _Report\Inputdata\EXPORT.xlsx”
To: “C:\Users\sudhir.k\Documents\UiPath\Generation_and_Circulation _of _IQC _Daily_MIS _Report\Inputdata\Daily Report”+System.DateTime.now.ToString(“dd/MM/yyyy”)+“.xlsx”
get error : Move File: Could not find a part of the path.
Try like this,
“C:\Users\sudhir.k\Documents\UiPath\Generation_and_Circulation _of _IQC _Daily_MIS _Report\Inputdata\Daily Report\”+System.DateTime.now.ToString(“dd/MM/yyyy”)+“.xlsx”
You missed a slash after daily report.
Thanks
still the same error,
I want output file name like “Daily Report today’s date”
Hi,
I think excel do not support slash in the name. There may be some work around I guess.
Can we give like this as below
“C:\Users\sudhir.k\Documents\UiPath\Generation_and_Circulation _of _IQC _Daily_MIS _Report\Inputdata\Daily Report - ”+System.DateTime.now.ToString(“dd_MM_yyyy”)+“.xlsx”.