Excel File Location

Help Studio
, , , , ,
1

How to Save a Excel File inside Current Years& Month Folder everytime.

Example Of the Structure that needs to be achieved
2022—>01---->Abc.xlsx
2022—>02---->Abc.xlsx

2

HI @anmita,

when you create the folder structure just let it be dynamic like -

“C\Users\”+Now.toString(“yyyy”)+“\”+Now.toString(“dd”)+“\”+ABC.xlsx

Thanks

3

Hi @Shikhar_Tandon
If the Folder is already Created for Date & Month. Then will it create again if we specify in dynamic way like you mentioned

4

In that case you can you use a path exists activity with folder property and check if the folder is already created by a boolean variable if its already present you can leave it as it is or else you can create that

5

Thanks @Shikhar_Tandon

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.