Hello,
I have data being split into 3 different sheets of a single excel file. I am able to write to a static excel file (by naming sheets in the excel file) with 3 different tabs created, however I want the "excel" (not csv please) output in todays date and my data still being split into the 3 sheets within that file.
Solved! Go to Solution.
@JosephSerpis Jo - one last one. The WF you provided has datetimenow with 10 of left which is giving me the date. But as soon as I change it to 19 to get hh:mm:ss in the file name, it errors out as excel does not recognise : in a file name. Is there a work around to get hh-mm-ss instead?
Hi @danishrizvi couple of ways you can do this amend the workflow to show how.
@JosephSerpis ignore the last part. I figured it out. Sorry for being a pain. And thanks a million for the help.
@JosephSerpis I used this in the formula tool and worked out good for me.
filename_" + DateTimeFormat(datetimenow(), "%Y-%m-%d %H-%M") + ".xlsx|||sheetName"
Thanks again.