Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Ouptput Excel (xlsx) template

Axis
7 - Meteor

Hi all, 

 

I did some research but didn't found the exact solution to my problem. 

 

I'm trying to output an Excel file in format .xlsx
I need to have a new file everyday with a timestamp in the name of the file. 

I want my output to be like an already existing Excel file. 
In first tab, I need my data from Alteryx with the same template as Excel (nice colors, formatting, ...). 

In the second tab, I need the exact same tab as the one from the Excel template. 

 

Summary : First tab = New data with same formatting as Excel, second tab = nothing change, New Excel file everyday. 

 

Usually I use a formula tool to create the full path name :

 

Full_Path_Example\'Name_Of_File' + DateTimeToday()
+ '.xlsx|||Name_Of_Sheet'

 

I hope my explanations are understandable, don't hesitate to ask me some questions. 

 

Thanks a lot if you could help as I'm a bit lost on how to do. 

 

Best regards,

Axis

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@Axis 
Can you give a sample output with some forget data?

Labels