Import Sheet from CSV/XLSX

Help StudioX
,
1

hello everyone
I’m creating a sequence in Studio X to import a csv file into a Smartsheet. I’m using the activity “Import Sheet from CSV/XLSX”. The process works fine but, I would like to repeat every day the process without generating a new Smartsheet on the folder. My first idea was to remove the “old” Smartsheet from the folder before import again, but seems like we don’t have the option “delete Smartsheet”. Other idea could be to rename the “old” and import again the csv file.
Take into account that this Smartsheet is referenced from others Smartsheets.
Any suggesrions here? I’ll apreciate a lot your comments and suggestions.

Thanks in advance.

2

@ivan.puig

You have to Create a new sheet Of name Smartsheet add date it will be different fronm other

"Smartsheet"+DateTime.Now.ToString("dd/MM/yyyy")
3

Hi Rlgandu
Thanks a lot for your quick answer. Problem here is that this Smartsheet (imported) is referenced by others Smartsheet using “Ranges” in a different formulas. So, in that case the name should be the same in order to not loose the references.

Thanks again for your support here

4

@ivan.puig

Use File Exists Activity
And then Use Rename file Activity or Move the File to the new Folder using Move File Activity
Import Sheet from CSV/XLSX