How to copy excel file from local to shared folder with time stamp as filename?

Help Studio
, ,
1

I have excel in my local need to share that excel to shared network path for eg path is like this (\htrewg\sample\test)
need to copy excel with name( test_19-07-23_14:13pm.xlsx)

Please help anyone

2

Assign - NewFileName: “test_” + Now.ToString(“yy-MM-dd_HHmm”) + “.xlsx”

Copy the Excel file to the shared network path, you can use the “Copy File” activity. Provide the source file path (local path with the new file name) and the destination file path (shared network path) in the “Copy File” activity.

Make sure to use double backslashes for the shared network path in UiPath, like this: "\htrewg\sample\test".

Regards

4

@vnsatyasunil

Assign:
sourceFilePath = “C:\Path\To\Your\File.xlsx”

Assign:
destinationFileName = “test_” + Now.ToString(“dd-MM-yy_HHmm”) + “.xlsx”

Assign:
destinationFolderPath = “\htrewg\sample\test”

Assign:
destinationFilePath = Path.Combine(destinationFolderPath, destinationFileName)

Copy File:
Source = sourceFilePath
Destination = destinationFilePath

5

path not supported error coming.
Path for eg is (“\htrewg\sample\test”)

6

path not supported error coming
path for eg is like this(“\htrewg\sample\test”)

8

Try double slash \ htrewg\sample\test\

9

@vnsatyasunil

Assign:
destinationFolderPath = “\\htrewg\sample\test”

Copy File:
Source = sourceFilePath
Destination = destinationFolderPath + “\” + destinationFileName

10

path not supported error coming again

11

with double slash also path not supported error coming

12

@vnsatyasunil

“\htrewg\sample\test”+ Now.ToString(“yy-MM-dd_HHmm”) + “.xlsx”

Try this

13

from local folder(“c:\test.xlsx”) to network shared path (“\htrewg\sample\test.xlsx”)
Is this possible with copy file or move file activities?

14

Hi @vnsatyasunil

currentDate = DateTime.Now.ToString(“dd-MM-yy_HH:mm tt”)
destinationPath = “\htrewg\sample\test\test_” + currentDate + “.xlsx”

Copyfile(“C:\path\to\your\file.xlsx”, destinationPath)

Hope it helps!!

15

it is working but I need file name like this test_19-07-2023_15:50:02.xlsx

16

@vnsatyasunil

“\htrewg\sample\test_”+ Now.ToString(“dd-MM-yyyy_HH:mm:tt”) + “.xlsx”

17

Try this

destinationPath = "\htrewg\sample\test"+“test_”+ currentDate + “.xlsx”

18

tried path not supported error

19

Assign
Datetime variable
Date_Var=Now
“test_”+ Date_Var.ToString+“.xlsx”

20

path not supported for this also

21

@vnsatyasunil

Include(Double slash)before the “htrewg” only

22

@vnsatyasunil Is this shared network path being accessed by multiple users?